nested Cell("contents", w/ cell contents reference)
I'm trying to reference the cell contents of a cell in a different worksheet
by using the cell reference contained in a cell of the current sheet
i.e. ThisWorksheet cell B1 evaluates to a value "F159"
=CELL("contents",'Other Sheet'!F159) is what I'm after
somehow I want to get that using the ThisWorksheet B1 reference?
=CELL("contents",'Other Sheet'! & cell("contents",b1))?????
how do I construct or concatenate the appropriate references to meet my needs?
--
Jim
|