ExcelBanter - How do I parse the cell reference function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I parse the cell reference function? (https://www.excelbanter.com/excel-worksheet-functions/214101-how-do-i-parse-cell-reference-function.html)

How do I parse the cell reference function?

I have an attendance roster with names down the left and dates across the top
in sheet1. I mark a cell if present. I then have detail sheets that have
all the persons data. I would like to define a cell in the detail sheet that
is what row the data is on and then use a command like ='Sheet1'!D (plus
contents of cell on current sheet). Something like ='Sheet1'!D'Sheet2'!F1
My goal is to have a formula that I can copy from sheet to sheet and simply
change the value of row reference in a cell.

How do I parse the cell reference function?

Have a look at the INDIRECT function in XL Help. I think this is what
you are after, though it is not very clear from your description.

Hope this helps.

Pete

On Dec 18, 12:34*pm, Phil wrote:
I have an attendance roster with names down the left and dates across the top
in sheet1. *I mark a cell if present. *I then have detail sheets that have
all the persons data. *I would like to define a cell in the detail sheet that
is what row the data is on and then use a command like ='Sheet1'!D (plus
contents of cell on current sheet). *Something like ='Sheet1'!D'Sheet2'!F1 *
My goal is to have a formula that I can copy from sheet to sheet and simply
change the value of row reference in a cell.