Reading Cells In another worksheet

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

Guest

I think I am approaching this wrong way and their might be an easier way any
help is appreciated.

I am trying to have a cell return a value from an adjacent “tab†within the
same workbook.

EX:
Cell “A1†contains the title of another worksheet, within the same file
(workbook)
In cell “B2†I want it to return the value (number) located in cell “D2â€
from the “tab†name defined in cell “A1†I tried this but for some reason
only get an error after entering it into the cell:
=ActiveCell.Range(A1).value2.â€D2â€
Is this correct?
 
Maybe

=indirect("'" & A1 & "'!" & "D2")

or maybe the suggestion at your other post????
 
Back
Top