Skip navigation

("equivalency") COPY of data in spreadsheet to new sheet?

392 Views 19 Replies Latest reply: Nov 6, 2013 2:52 PM by hotwheels 22 RSS
1 2 Previous Next
hotwheels 22 Level 1 Level 1 (0 points)
Currently Being Moderated
Nov 4, 2013 9:27 AM

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)
  • Jerrold Green1 Level 7 Level 7 (28,270 points)

    HW,

     

    The best way is to divide and conquer. Those 18 Sections would be easier to manage if they were 18 Tables. It's easy to pull a table apart into sub-tables.

     

    Jerry

  • Wayne Contello Level 6 Level 6 (12,800 points)

    select the cells in the table drag onto the canvas.

  • Jerrold Green1 Level 7 Level 7 (28,270 points)

    HW,

     

    Two sentences on how to split part of a table into a separate table.

     

    1. Select and Copy (Command-C)

     

    2. Click off the table and Paste (Command-V)

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,270 points)

    You can Paste a range of cells to a Sheet and a new table will be created. If that range of cells had references outside of the range, you may have to reestablish the references.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,270 points)

    HW,

     

    I don't know how you are organized there. Hard to guess what may happen. My test here shows that it can work.

     

    Original...

    Screen Shot 2013-11-05 at 3.05.59 pm.png

    Modified...

    Screen Shot 2013-11-05 at 3.08.53 pm.png

     

    Jerry

  • Wayne Contello Level 6 Level 6 (12,800 points)

    HW,

     

    We have given you multiple examples.  If you do not understand the concept then you should post an example for your situation so we can specifically help you.  What you want is possible.  The insurmountable task is getting to the specifics for your situation.

  • Jerrold Green1 Level 7 Level 7 (28,270 points)

    Please post an example. I just not good enough at this to help you with such a broad problem statement.

     

    Jerry

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.