Compiling TabName on one Sheet?

[Petitboeuf]

Dear Experts

Is there a way to compile all the name of each worksheet tabs on one spreadsheet e.g.

A1 = Sheet1 (name of)
A2 = Sheet2 (name of)
etc...

Many thanks in advance!

[dominicb]

Good afternoon Petitboeuf

You will need a macro to do this. I can list one for you, or you can download my add-in via the link below and once installed go to Ultimate > Sheets > Create Index Sheet. You will also have the option to turn each sheet name into a hyperlink to the relevant sheet.

HTH

DominicB

[Carim]

Hi,

A quick and dirty code ...to generate an Index of Worksheets tab names ...

Please Login or Register  to view this content.