Linking Question

[Steve]

Suppose I have numerous tabs in a spreadsheet and let's say one is call "Co
1". If another tab has Co 1 in cell A1 and Co 2 in cell A2. If I am in cell
B1, is there a way to use the contents of cell A1 to link to tab "Co 1"?

 

[tina]

if you're using Excel, suggest you post the question to an Excel newsgroup.
this newsgroup answer questions about using macros in MS Access relational
database software.

 

[Steven M. Britton]

U would just hit the = on the other sheet then click over onto the sheet that
you want to reference. Then the cell would read something like 'Co1'!$A$1 -
this is the reference to the other sheets cell. Then on the sheet you're
interested in using just =A1 and it will have the same value.