View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe F Joe F is offline
external usenet poster
 
Posts: 1
Default Summary sheet from tab names

I have been racking my brain on how to make this work! I have created a
workbook with 70 tabs and a summary sheet linking to specific info on each
worksheet. I would like to be able to change the tab name and have that
change on the summary sheet as well. Is this possible?

Examble tab name is currently generic "Person 1" Summary sheet is also
(manually) entered as "Person 1" I want to be able to rename the tab to Jim
Smith and have that update on the summary sheet as well.

I have not worked with macros

Thanks

Joe