1 2 Previous Next 19 Replies Latest reply: Nov 6, 2013 2:52 PM by hotwheels 22
hotwheels 22 Level 1 Level 1 (0 points)

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)
1 2 Previous Next