View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
Posts: 105
Default 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