Summary page -advancing name of sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with 52 sheets, the names of which alternate in the following pattern: BioPP15, AAPP15, BioPP16, AAPP16, BioPP17, AAPP17, etc.

I have a summary page which I'm using for certain key #'s from each sheet.
Example of formula for sheet BioPP15 - =BioPP15!$21

Question - how do I need to edit this formula so that when I drag it down it will read
=BioPP16!$21
=BioPP17!$21
=BioPP18!$21 etc.

Thanks in advance
 
carrera

To start with, =BioPP15!$21 is not a valid cell address.

Perhaps you meant =BioPP15!A$21

To increment sheet numbers use the following

=INDIRECT("BioPP" & (ROW()) & "!A$1")

Drag/copy down and it will increment.

Your start row will have to be adjusted.

Gord Dibben Excel MVP
 
Good Morning Gord
You're right, I inadvertantly left off the column designation in my question. Good catch. It was in my formula though.

I'll try this solution as soon as I can.
Thanks for the assist.
 

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

Summary Page - advancing name of sheet - PART DEUX 3
Populate Data from Summary Sheet 5
3-D References 4
Page Numbers/Names listed on a Summary sheet? 5
Make all values of a 3D named range appear on summary sheet 1
Summary from multiple sheets 1
Summary sheet from tab names 3
Copying a formula down a summary sheet 4

Back
Top