Learn Excel 2010 - "Rename 31 Worksheets": Podcast #1489
Loading...
Uploaded by bjele123 on Dec 13, 2011
Yesterday, in Podcast Episode #1488, Bill showed us a cool way to make 30 copies of a worksheet. However, after creating the worksheets we were left with strange names like Sheet1 (2), Sheet1 (3) and so on. Horrible! Today, in Episode #1489, Bill shows us how - with one line of code in the VBA Immediate Window - to solve the remaining issue of renaming the new Worksheets.
...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!
*Kindle is Coming to 'The MrExcel Excel Store'! Stay Tuned!*
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
- 13 likes, 0 dislikes
-
- 9:25
How to Use VBA to Add a Date / Time Stamp When You Edit a Record in Excelby DannyRocksExcels1,205 views
- 7:39
Excel VBA tutorial 23 Functions.flvby Malfunction91,120 views
- 23:54
Online VBA Classes from Chandoo.org - Topics and Detailsby ExcelTutorials2,869 views
- 5:10
Creating Userform In Excel VBAby DCGSTube507 views
- 13:03
Write a Macro to Update an Excel Worksheet Tab Nameby DannyRocksExcels2,722 views
- 7:35
DMX - Rips 50 Cent & Ja Rule on interview Oh..Ohby Mormodona153,247 views
- 9:41
Mr Excel & excelisfun Trick 75: Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX?by ExcelIsFun4,192 views
- 5:09
SAY GEEK - EXCEL TIPS AND TRICKS - CONDITIONAL FORMATTING Excel 2003by gobigblu91,795 views
- 9:06
Mr Excel & excelisfun Trick 84: Count Calls Every 15 Minutes Count Times Between Upper & Lower Limitby ExcelIsFun1,548 views
- 5:50
Mr Excel & excelisfun Trick 90: Remove Earlier Duplicates, Keep Last Duplicateby ExcelIsFun2,184 views
- 52:08
Excel 2010 - 20 New Features - Northwest Accounting Educators Conference 2011by ExcelIsFun3,010 views
- 1:58
Learn Excel 2010 - "Numbers to Words in Excel": Podcast #1431by bjele1232,039 views
- 5:06
Learn Excel 2010 - "Worksheet Name in Cell": Podcast #1490by bjele1231,078 views
- 3:37
MrExcel's Learn Excel #680 - Timestampby bjele1234,068 views
- 3:09
Learn Excel 2010 - "Variable Chart by Dropdown": Podcast #1493by bjele123810 views
- 1:59
Excel 2007 - Renaming a Worksheetby SpreadsheetHowTo109 views
- 9:55
Dueling Excel - "Find Cubic Feet": Podcast #1492by bjele123754 views
- 1:31
Learn Excel 2010 - "Removing Duplicates": #1433by bjele123938 views
- 6:21
Learn Excel 2010 - "Hosted PowerPivot" #1432by bjele1231,611 views
- 6:57
Jackie Evancho "Pie Jesu" ~ America's Got Talent TOP 10by AmericanBestTalent3,233,954 views
AWESOME AWESOME AWESOME!!!!! THANK U!!!! ^^V
msashikin85 2 months ago
@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?
ryanjaimee2 2 months ago
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").Value : Next
I'm always impress.
Thx a lot.
SourceSure 2 months ago
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.
lantere 2 months ago
Many thanks for this very handy trick.
TaurusPresents 2 months ago
@osmrducks1 , That is a great trick!
ExcelIsFun 2 months ago
Easy way that you found, thx!
danielvondavis 2 months ago
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.
osmrducks1 2 months ago
Bill, super cool trick. Wow, that saves a whole lot of time. Thanks.
krn14242 2 months ago