("equivalency") COPY of data in spreadsheet to new sheet?
i am having a bit of an issue figuring out how to finalize a spreadsheet. i have a spreadsheet that is about 20 Columns wide and 800 or so Rows long. The Rows are divided up into 18 or so SECTIONS.
i also have a set of TOTALS that summarize the various sections at the BOTTOM so this area is about the size of an 8 x 11 inch sheet and represents what i will be sending out. however, i also have a set of totals on the RIGHT that itemize everything horizontally.
everything obviously is tied into everything else on this sheet and i would not like to COPY the results of the 8 x 11 inch sheet area at the bottom to another /sheet/ so that i can reformat this slightly but also so i can add some "percentage completion" calculations. i would also like to COPY the results on the RIGHT to another sheet so that i can DELETE some of the rows that do not have information in them for this particular project but in a way that will retain the original data. basically this is a template and i want to retain the template but i still have to condense everything down so that it will fit on a page.
for some reason i am not having a very easy time figuring out how to do this.
is there a way to do some kind of "equivalency copy" so that i tell number to copy exactly what i have to another sheet - so that it will update when the original sheet is changed and so that i can edit the "equivalent copy"?
i cannot imagine doing this cell by cell by cell and the spreadsheet is so large at this point i am not sure how keeping it all on the same sheet is going to be manageable.
TIA
MacBook Pro, OS X Mavericks (10.9)