PC Review


Reply
Thread Tools Rate Thread

Auto worksheet name?

 
 
Esradekan
Guest
Posts: n/a
 
      7th Aug 2011
Dont think this post made it, so posting again. Apologies if I am
duplicating.

My problem is this:

On the first sheet (named 'Index') of the workbook in cells B2-B21, I
have a list that changes from year to year. I need to have a
worksheet named from each of the names in the list and need to have
the rest of the worksheets in the book named accordingly. (ie B2 =
Sheet2, B3 = Sheet3 etc etc) Can this be done? and if so, how? Im
using Excel 2010 in a macro enabled book.

Hope someone can help.

TIA

>(^-^)<

Esra
 
Reply With Quote
 
 
 
 
joeu2004
Guest
Posts: n/a
 
      7th Aug 2011
Let's not beat up Esra for posting twice. The problem is with Google
Groups. Even though postings are successful, they do not appear at
http://groups.google.com. Esra also will not see any responses -- at least,
not until GG fixes the problem.

(I have reported the problem twice in the past week. GG still has not done
anything about it.)


----- original message -----

"Esradekan" <(E-Mail Removed)> wrote in message
news:12ca24d8-0ae6-4da2-b6a1-(E-Mail Removed)...
> Dont think this post made it, so posting again. Apologies if I am
> duplicating.
>
> My problem is this:
>
> On the first sheet (named 'Index') of the workbook in cells B2-B21, I
> have a list that changes from year to year. I need to have a
> worksheet named from each of the names in the list and need to have
> the rest of the worksheets in the book named accordingly. (ie B2 =
> Sheet2, B3 = Sheet3 etc etc) Can this be done? and if so, how? Im
> using Excel 2010 in a macro enabled book.
>
> Hope someone can help.
>
> TIA
>
>>(^-^)<

> Esra


 
Reply With Quote
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto worksheet name? Esradekan Microsoft Excel Worksheet Functions 1 7th Aug 2011 04:55 PM
how do I auto sum several worksheet cells on to a new worksheet? =?Utf-8?B?S2FyeW4=?= Microsoft Excel Worksheet Functions 3 18th Mar 2006 11:49 PM
Auto Worksheet superkopite Microsoft Excel Misc 5 29th Jan 2006 06:12 PM
auto updating a worksheet =?Utf-8?B?ZXJpa2E=?= Microsoft Excel New Users 2 28th Apr 2004 01:59 PM
Auto Sum from another worksheet? Krefty Microsoft Excel Worksheet Functions 0 13th Aug 2003 04:24 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:35 AM.