sheet reference

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

Does anyone know how to "automatically" update a sheet
reference without changing the cell reference?

I have summary page which links to the same cell on each
page.

Example:

(cell 1) customer1 (cell 2) =Sheet1!$A$3
(cell 1) customer2 (cell 2) =Sheet2!$A$3

I would like to update the sheet reference for each tab
i've created for each customer. Autofill doesn't work -
it copies the formula exactly.

Any help is appreciated.
 
=INDIRECT("Sheet"&ROW()&"!A3")

This will work starting in row 1.

HTH
Jason
Atlanta, GA
 
Back
Top