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

K

KenK

I am trying to link the data in a cell in another sheet by using a viable to
determine the sheet link.
 
B

Bob Phillips

=INDIRECT(A1&"!H10")

where A1 holds the sheet name, and H10 is the cell on that sheet being
referred to.
 
B

Bernard Liengme

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
 
D

Dave Peterson

if A1 contains the worksheet name:

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

will return the value from B99 of that worksheet.
 
Top