Reading Cells In another worksheet
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?
|