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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine information from multiple file into many different files. 2
clip art shifts 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Gather data from several workbooks. 2
Excel In Excel how can I block the contenent of a cell? 0
Excel Need Countifs Formula Help 0
Printing using Macros for Multiply Co-workers in Excel 2
Write a button to run macro on *ANY* chart area clicked. 1

Back
Top