How do I parse the cell reference function?

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

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.
 
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
 
Back
Top