N
navel151
I need a way to get text from a cell put into a function such that the text
fills in the name of the worksheet to look for the data in.
i.e. I want to look for cell B2 in worksheet test, then the next cell down I
want to look for cell B2 in worksheet answer, etc but I don't want to have to
modify the formula to input the worksheet name every time. I want a way for
the worksheet name to be grabbed from an adjacent cell and populate the
formula that already has the cell B2 in it.
Thx.
fills in the name of the worksheet to look for the data in.
i.e. I want to look for cell B2 in worksheet test, then the next cell down I
want to look for cell B2 in worksheet answer, etc but I don't want to have to
modify the formula to input the worksheet name every time. I want a way for
the worksheet name to be grabbed from an adjacent cell and populate the
formula that already has the cell B2 in it.
Thx.