Linking Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"?
 
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.
 
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.
 
Back
Top