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

Matthew.

macrumors regular
Original poster
Dec 27, 2008
155
0
In Numbers '08, is it possible to link cells/columns between sheets; so that in the below spreadsheet selecting an item from Column A in "Hub Dimensions" sheet in the drop down box of the "Spoke Calculator" sheet would fill out the cells in Column D of the "Spoke Calculator" sheet with data from the related cells in the "Hub Dimensions" sheet?

numbers.jpg


Cheers.
 
The notation would be something like:

=Sheet 2 :: Table 1 :: B4
=Sheet 2 :: Table 1 :: C4
=Sheet 2 :: Table 1 :: D4

etc.

mt
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.