Posted to microsoft.public.excel.programming

Jeff Lowenstein Jeff Lowenstein is offline

external usenet poster

Posts: 14

Automatic Sheet Naming

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Naming a sheet	Mike	Excel Discussion (Misc queries)	3	March 7th 07 08:43 AM
Automatic naming Worksheet tabs	rhani111[_9_]	Excel Programming	2	June 26th 06 01:40 PM
Automatic naming Worksheet tabs	rhani111[_8_]	Excel Programming	4	June 26th 06 10:37 AM
Automatic Range Naming using Advanced Filter?	ArthurJ	Excel Programming	2	August 26th 05 04:51 PM
Automatic sheet naming	Hans Weustink	Excel Programming	3	October 23rd 03 09:32 AM

All times are GMT +1. The time now is 06:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us