Incrementing Worksheet numbers???

  • Thread starter Thread starter JAMES SYLVESTERSR
  • Start date Start date
J

JAMES SYLVESTERSR

I would like to know if there is a way to increment page numbers. I want to
reference worksheets 2-32. On worksheet 1 cell a1 references sheet2!$S$2.
I want cells in the same column to reference Sheets 3-31 while referencing
cell $S$2 on each worksheet. I need to do the same for 24 columns.

thanks for your help
 
Use another column to number the sheets you have
ie>K1:K32 number 2 thru 32
Then use the formula
INDIRECT("Sheet"&K1&"!S2")
and drag down as a far as necessary.

You can use a bigger formula to increment the sheet number but this is
easier.
 
Jay

In Sheet1 at A1 enter =INDIRECT("Sheet" & (ROW()+1) & "!$S$2")

Drag/copy down to row 31. Replicate in other columns?

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Back
Top