HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE?

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

Guest

I am trying to get my worksheets to either number a specific cell in each
worksheet in sequence or display the sheet name and I will rename the sheets
in a sequence.
 
Hi!

To get the sheet name:

The file must already exist. In other words, it must have already been
created and saved.

Group all the sheets together that you want to do this to.

Enter this formula in the cell where you want the name to appear:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Ungroup the sheets.

Biff
 
You must log in or register to reply here.

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

Search adjacent cells in Column for sequence 3
Excel Highlighting duplicates 0
Excel Sequential Numbering System 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Variable to rename a tab in a worksheet via VBA 5
creating table of content in excel workbook 1
Hyperlink to a specific worksheet in another workbook 5

Back
Top