P
ptrip
I have a simple formula which reads:
='P1'!$L$52
Where 'P1' is a worksheet name.
I want the value 'P1' to be the contents of another cell.
Reason being:
This worksheet is a summary worksheet. Each row contains multiple values
(or formulas) from a different worksheet. I'd like to have one column where I
type the worksheet name and have that name automatically inserted into the
formulas throughout the row.
I apologize if this has been asked a hundred times before, I just don't know
a good search string to enter!
Thanks for your help.
='P1'!$L$52
Where 'P1' is a worksheet name.
I want the value 'P1' to be the contents of another cell.
Reason being:
This worksheet is a summary worksheet. Each row contains multiple values
(or formulas) from a different worksheet. I'd like to have one column where I
type the worksheet name and have that name automatically inserted into the
formulas throughout the row.
I apologize if this has been asked a hundred times before, I just don't know
a good search string to enter!
Thanks for your help.