Hi,
I am trying to make a reference to different worksheets within a formula based on the what text the user selects from a combo box.
The basic idea is to pull the data from cell A2 in a worksheet, as chosen.
I can get the text matching the work sheet name to display (in a cell B66 on a defined sheet) no problem using both below:
=INDIRECT("' '!$B$66") or
=(CONCATENATE("",' '!B66,""))
I can also get the data I need to display if I have another cell (C66) with A2 typed in with this:
=INDIRECT("'"&' '!B66&"'!"&' '!C66)
And also using this:
=INDIRECT(CONCATENATE("'",' '!B66,"'", "!A2"))
But what I then need to be able to is copy this formula across rows and down columns so that I can act on a whole grid of data and that's where I get stuck. Obviously =INDIRECT("'"&' '!B66&"'!"&' '!C66) doesn't do it as C66 becomes C67 etc and I lose the reference, and the final one is just text so doesn't copy and move the A2 reference.
Any pointers at this stage would be greatly appreciated!!
Thanks D
Bookmarks