Cell reference question
I would like to enter a value in a cell which represents
a row in another sheet and have a formula(s) reference
that cell. ie the current formula is =Import!P9-B6; what
I want to accomplish is to enter the 9 in a cell (A10)
and have the series of formulas look to that reference
such as =Import!P&A10-B6 where A10 contains a 9.
Any help would be appreciated.
Tim
|