How do I use a Cell Value to link other sheets in a workbook

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

Guest

I am trying to link the data in a cell in another sheet by using a viable to
determine the sheet link.
 
=INDIRECT(A1&"!H10")

where A1 holds the sheet name, and H10 is the cell on that sheet being
referred to.
 
Not too clear. What to try again using more ink?

You know to use =Sheet2!A1 to gent the value form A1 in Sheet2 to cell in
another sheet?

best wishes
 
if A1 contains the worksheet name:

=indirect("'" & a1 & "'!b99")

will return the value from B99 of that worksheet.
 
You must log in or register to reply here.

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

linking cells to other sheets within a workbook 1
Paste Values in linked Cells Only 4
how do i link one sheet to another sheets cell of the same workboo 1
Linking blank cells 1
How to create absolue path link to another workbook (Excel 2003) 1
linking cells 1
How do I link cells between to sheets in MS Excel? 3
Unlink cells- how? 0

Back
Top