Learn Excel 2010 - "Rename 31 Worksheets": Podcast #1489

[msashikin85]

AWESOME AWESOME AWESOME!!!!! THANK U!!!! ^^V

[SourceSure]

Here is another variation...

I adapted it to my sitation.

To named the tab from a present and specific cell value from each of them.

For i = 1 to 3 : WorkSheets(i).name = WorkSheets(i).Range("B2").Valu­e : Next

I'm always impress.

Thx a lot.

[ryanjaimee2]

@SourceSure, I couldn't get this to work for me. I have a master data sheet and I want to pull from column B starting with B3:B100 to name each worksheet in my workbook. Any ideas?

[lantere]

Here is a slight variation of your macro:

For i = 1 to Worksheets.Count : Worksheets(i).Name = "Day " & i : Next

That way you don't have to know/count how many Sheets you have to rename.

And it bypass the 28/29 or 30 day sheet error.

[TaurusPresents]

Many thanks for this very handy trick.

[danielvondavis]

Easy way that you found, thx!

[osmrducks1]

Awesome!..... That is the way to go if you already have 30 sheets, but if you haven't made your sheet copies yet, then just name the first worksheet Day (1) and excel will increment the number as you copy automatically.... Thanks Bill, you have taught me a lot, keep up the great work.

[ExcelIsFun]

@osmrducks1 , That is a great trick!

[krn14242]

Bill, super cool trick. Wow, that saves a whole lot of time. Thanks.