changing parts of formula

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

Gord Dibben

Enter this in A1 of a new sheet then drag across.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
locking part of look up formula 2
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6
Help me for exact formula 2
Fill formula down for cells 74 rows apart 3
Excel Copy COUNTIF while retaining reference 7
Conditional sum in a named range 8
vlookup + if formula help! 7

Top