I want to Rename the next 15 tabs based on the inputs in the first tab

[rshnkmr39]

I have an instructions tab followed by 15 item level tabs.

Say i Have 15 items in the first tab from cell "A1" to cell "A15"

the items are
267-00-0006
267-01-0002
267-02-0005
267-02-4281
267-03-4046
and so on

the following 15 tabs should be renamed as mentioned above in the same order i.e the second tab as 267-00-0006........

[AlvaroSiza]

Do the tabs already exist, or do they need to be added/created?

[rshnkmr39]

the first tab should remain untouched and the values in A1 to A15 can be changes as and when desired

[EXCEL WIZZARD]

I can help you with this, Please add me on S kk.,y p.e : Khushboo.enuke

[HaHoBe]

Hi, rshnkmr39,

maybe like this:

Please Login or Register  to view this content.

And the event for changing directly from Worksheet1:

Please Login or Register  to view this content.

Ciao,
Holger

[rshnkmr39]

Hi Holger,

This is awesome.Hope the contents of the workbook do not change i.e data

[rshnkmr39]

Hey Khusboo,

Thanks ! I do have Skype installed..

[HaHoBe]

Hi, rshnkmr39,

Hope the contents of the workbook do not change i.e data

The name of the worksheets 2 to 16 will change. You should take into consideration that a worksheet name canīt be longer as 30 characters and may not include special characters like \\/:\*\?""<>\|[].

Ciao,
Holger

[Winon]

@ HaHoBe,

Hello Holger,

Very nice,

In the Sub I would add the following though.

Please Login or Register  to view this content.

to prevent the Code to "Bom" out if the Range in Column A on WorkSheet1 is not completely populated.

Oh yes, almost forgot. The sub does not want to Run with the name as

Please Login or Register  to view this content.

I had to change it to Sub Test. Do you know why?

[HaHoBe]

Hi, Woinon,

the ways of both macros as well as checking the sheetname by a function like

Please Login or Register  to view this content.

would be ideal - but I guess that in appr. 90+% of all cases it would not be needed. If you want a reliable code the check for the length of the name should as well be included.

Please Login or Register  to view this content.

I could not reckognize any problems with the name of the procedure when I inserted the code into a new workbook - and the old one is long gone.

Ciao,
Holger

[rshnkmr39]

Great ! Could you let me know how to select multiple tabs and perform a copy paste of a desired range of cells in each tab.

Example I have a main sheet followed by 15 tabs

Main sheet Has an input J10

IF J10 = AU3 of the 15 item tabs
AU10 to BA 11 needs to be copy pasted as values

If J10 in the main sheet=BD3
then BD10 to Bj11 should be copy pasted as values and so on


If you need more detail please refer to the below link

http://www.excelforum.com/excel-prog...iple-tabs.html

[Winon]

Hello rshnkmr39,

Edit: Sorry rshnkmr39. I see that you have done what I was asking for below. So please ignore my post..

Your last post is way of from the topic, and I feel that HaHoBe has gone to great lengths to give you enough to work with.

So may I suggest that you mark this Thread as Solved, and start a new Thread with your issue at hand as per your last post.

Thank you.

@ HaHoBe,

Nice work Holger!