Reverencing Cells in another worksheet

[GMD]

Hi I have two sheets in a workbook.

I'm using this:

='worksheet1'!D2 to get information from the first worksheet into a cell on the second worksheet.

What I want to do is populate a cell on worksheet two with the cell number to reference on worksheet 1. I can't get a formula to be accepted that will reference a cell on worksheet 2 that might say F20 so that it replaces D2 in the formula. Is it possible to do this?

thanks

 

[JoeMo]

Hi I have two sheets in a workbook.

I'm using this:

='worksheet1'!D2 to get information from the first worksheet into a cell on the second worksheet.

What I want to do is populate a cell on worksheet two with the cell number to reference on worksheet 1. I can't get a formula to be accepted that will reference a cell on worksheet 2 that might say F20 so that it replaces D2 in the formula. Is it possible to do this?

thanks

Say the cell on sheet2 is D2 and contains F20:
=INDIRECT("'worksheet1'!"&D2)

 

[GMD]

Thanks worked great.

Say the cell on sheet2 is D2 and contains F20:
=INDIRECT("'worksheet1'!"&D2)