increming sheet
-
Wednesday, July 21, 2010 10:47 AM
I have an excel file with 32 sheets. The first sheet is a summary page. On the summary page I would like cells A1:A10 to display what is in cell A1 on sheets 2 through 11.
Example of summary page
A1 = A1 on sheet 2
A2 = A1 on sheet 3
A3 = A1 on sheet 4
and so on
Is there a formula I can enter in cell A1 and drag down to A10??
All Replies
-
Wednesday, July 21, 2010 12:28 PM
In A1, enter:
=INDIRECT("Sheet" & ROW()+1 & "!A1") and copy down
- Marked As Answer by Will BuffingtonMicrosoft Employee, Moderator Thursday, July 22, 2010 10:04 PM
.png)
