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
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