changing parts of formula

  • Thread starter Thread starter Chay
  • Start date Start date
C

Chay

Is there any way I can adapt how a formula copies across, apart from doing it
manually? I want part of the formula to change. For example Sheet1!$a2 when
copied across will show Sheet1!$a2 and so on. I want it to show Sheet2!$a3
and then Sheet3!$a2.
 
Enter this in A1 of a new sheet then drag across.

=INDIRECT("Sheet" & (COLUMN()) & "!A2")


Gord Dibben MS Excel MVP
 
Back
Top