Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

SnackPack210

macrumors newbie
Original poster
Apr 5, 2011
2
0
I didnt get much of a reply on the last time I asked, so lets try this with pictures. I want to make one spreadsheet with all the info (plain spreadsheet pic) and have another sheet (colorful spreadsheet pic) that will update with changes made to the plain spreadsheet.
Is what I want to do possible at all? or am I trying to do too much?
 

Attachments

  • Condensed Sort Guide.jpg
    Condensed Sort Guide.jpg
    435 KB · Views: 120
  • Picture 3.png
    Picture 3.png
    38.7 KB · Views: 91
I don't think linking spreadsheets in Numbers is possible. Do you have access to Excel?

If so then you will need to link the Master (plain) spreadsheet cells with the colourful one. Depending on the data within the Master, and the type of calculations needed, these formulas could get reasonably complicated, however it could be done.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.