Cell reference question

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=Trend question 1
Arrays and scattered cell values or another way? 16
How to do this with macro? 2
setting one worksheet cell range reference to another worksheet 1
Defining a range as a subset of cells in another range 12
=OFFSET(MATCH(My frustration continues!)) 1
duplicating cells in diffrent sheets 1
Finding Next Largest Number Based on Criteria 3

Back
Top