Dynamic reference to another tab name
I need this way of referencing to other sheets (TABs). I tried it and it
works BUT the D6 reference is no more changing when I copy it over a huge
range, for instance changing to D5, D4. Any medicine for this?
Morten
"Biff" skrev:
Try this:
=INDIRECT("'"&A2&"'!D6")
Biff
"Angus" wrote in message
...
Currently I have a cell with this formula:
=A2 & !D6
Cell A2 contains the name of another tab in the same book and I wish to
display the value from cell D6 of that sheet. Clearly the above syntax
is
incorrect but what should it be?
Thanks in advance.
|