Thread: list tab name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A
 
Posts: n/a
Default list tab name

Is there a way of listing all tab names in a workbook into one sheet.

By way of example, I have a questionaire which has been completed by 50
people. Each sheet tab is named as the persons name. I would like to list the
names of each tab onto a summary page and also have the total score for each
tab (which is the same cell on each sheet).

Any help would be appreciated.
A