Automatic Sheet Naming

Jeff Lowenstein

Guest

Posts: n/a

11th Mar 2008

If I have a list of people in the A column, is there a way for the worksheet
tabs reflect those names automatically?

Example:

Sheet1:
A1: Joe
A2: Bob
A3: Bill

Sheet2 renames to what is in A1, or Joe
Sheet3 renames to what is in A2, or Bob
Sheet4 renames to what is in A3, or Bill

Then I rename A1 to Albert, and Sheet2 or the “Joe” sheet automatically
becomes Albert now. Thanks!

« Saving Excel Workbook to a stream using Excel 2007 Plug-in | Excel Data to Powerpoint »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic tab naming	Rex	Microsoft Excel Programming	2	25th Feb 2009 12:40 PM
naming a sheet the same as a cell in that sheet	des-sa	Microsoft Excel Misc	3	16th Jul 2008 08:08 PM
Automatic Sheet Naming	Jeff Lowenstein	Microsoft Excel Programming	4	11th Mar 2008 01:49 PM
Copying a formatted "template" sheet and naming new sheet via user form	Neale	Microsoft Excel Programming	1	31st May 2007 04:02 PM
Automatic sheet naming	Hans Weustink	Microsoft Excel Programming	3	23rd Oct 2003 09:32 AM