Changing the row reference in a link

B

Bud

I would like to be able to change the row that a cell references by entering a number in a cell. I have a sheet that automatically updates various data (such as stock prices). I then have another sheet that has a standardized report format. I would like to have a cell linked to the stock price (such as =Data!F19) but have a cell so that I could change the row link from 19 to another number by just entering that number in a cell on the standardized report sheet (something like =Data!F(A2)). I would like to avoid a macro if possible..

Thanks
 
R

RagDyer

Try this:

=INDIRECT("Data!F"&A2)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I would like to be able to change the row that a cell references by entering
a number in a cell. I have a sheet that automatically updates various data
(such as stock prices). I then have another sheet that has a standardized
report format. I would like to have a cell linked to the stock price (such
as =Data!F19) but have a cell so that I could change the row link from 19 to
another number by just entering that number in a cell on the standardized
report sheet (something like =Data!F(A2)). I would like to avoid a macro if
possible...

Thanks
 
Top