Rename All Sheets From A List... In One Step

[@ronyshafiq]

I am from bangladesh. I watch many vedio for this problem.. and finally I can say it's simple and very easier then others. Thanks a lot sir

[@abdulkaderk2169]

As a specialist teacher, I have to deal with multiple classes. I used to name each sheet as per your introduction. Thank you for this valuable and short method. Since I use all the sheets to insert students names, I named Sheet 1 as YEAR LEVELS created number of sheets according to the number of year levels. Thanking you again.

[@Officeinstructor]

I am glad Abdulkader my video helped you in your work situation

[@elephantsarenuts5161]

No extraneous chat. Short and directly to the point. Well done.

[@Officeinstructor]

Thank you for the motivating comment

[@dimitrz2000]

Thanks very useful , quick question once all the sheets have been renamed , can I come back and delete the macro if a) I dont want to rename more sheets in future b) I want to retain a macro free workbook ?

[@Officeinstructor]

Yes, you can, Vinod

[@alanmclean1399]

Fantastically clear explanation and helpful visuals that compliment it perfectly. Really helpful for a novice VBA user like me

[@berthony65]

Good day, Nabil, I am trying to follow along but I do not have the same Excel version you have, which I believe is a problem. Our tool bars are different and I also do not have access to visual basic editor. Is there another way to range the a1 column and sheets? Thanks

[@sparkleboyd6601]

THIS WAS AWESOMEEEEEEEEEEEEEEEEEEEEEEEEEEE! I am so glad I found this video Thank you! I was able to follow your instructions and I renamed 23 tabs in a matter of minutes. Much appreciated! God Bless you!!

[@joselrivas]

Hi everything work perfect , but I want to star putting name on the second sheet . What can I change in the coding ?

[@sheritingle7896]

Thank you very much for an easy to follow video. Very thankful to have found your channel. GREAT STUFF!!

[@Officeinstructor]

You're very welcome Sheri

[@froidbisebenjamin2285]

What a great clear video! You explain clearly what you do and what it means. That is what is helping many people to understand!

[@MdKhan-cc1qs]

I do not know abc of VBA. But by this video I am able to rename lot of excel sheets at a single click! Thanks

[@Officeinstructor]

Congratulations on creating your first code

[@jeraldthalaiva85]

Sir, incase u have to change name is automatically rename change or not??

[@countduckula9977]

Hi Nabil, Thank you for posting this extremely useful video. Your VBA explanation was clear & concise.

[@Officeinstructor]

You are most welcome

[@Officeinstructor]

You are most welcome

[@clentwilliamsii225]

Thanks for the lesson, however I am trying to use this format in a workbook in which the naming sheet is the second sheet in the workbook and will only rename sheets after the naming sheet. Can you help me?

[@Officeinstructor]

Hi Assuming that the first sheet is named "Nabil" and we want to start renaming from the second sheet having the list of names, then I will add a conditional statement that evaluates the sheet name first before renaming, as follows: Sub RenameSheets() Dim i As Integer i = 1 For Each Sheet In Sheets If Sheet.Name "Nabil" Then If Cells(i, 1) "" Then Sheet.Name = Cells(i, 1).Value i = i + 1 End If End If Next Sheet End Sub Good Luck

[@abdelkrimmesaiahmed662]

Great video, but i wondering if I want the sheet where the list of names don't to be named with the code how to do this?

[@vigneshkathirkamar3113]

Thanks Nabil for this video. I am beginner in vba and your videos are helping me to learn the concepts slowly. Kudos, keep going 🙌

[@youssefb3599]

This is a great job. I do not use VB, but the way you show it and the steps are clear to anyone. Thanks a lot for this video. I am always dealing with this issue, and finally found the answer. However, how to deal with multiple excel files for which, let's say, we need to rename sheets using the same group of names? Thanks.

[@Officeinstructor]

Performing an action on multiple files requires looping over workbooks

[@robertmillar2037]

Great work, can you do the VBA for sheet name AND add sheets depending on how many rows contain data?

[@marlonhalliday3274]

How do you indent your vb code is there a short cut key!! you use. Thanks

[@Officeinstructor]

Just put your cursor at the beginning of the line and hit TAB as many times as you want

[@epdiaz5813]

This is an AMAZING VIDEO! I spent so much time on other videos and I would always get an error or a bug and could never figure it out. Thank you so much! I want to ask, how do I get the sheets to start renaming beginning from the second sheet, as I don't want Sheet 1 (The list of names) to be renamed as the first name on my list?

[@ronnie9096]

when using F8 on the fourth row "Sheet" is highlighted as an error. compiler error message is "variable not defined" so when defined sheet as worksheets, it worked thanks for the amazing tutorial.

[@Officeinstructor]

Glad it worked

[@sumitgupta9118]

Can I rename worksheet name as workbook?? For single sheet only?? I have number of files in Excel to rename??

[@abbasalishah7211]

Sir what if we want "name" to be the date... I. E my workbook is named "july, 2021" and want to name sheets by date for every single day. Pls guide

[@gregcalvert4645]

Stumbled on your channel. Love it, straight to the point useful videos. Thanks BTW, subscribed after the 3rd video.

[@Officeinstructor]

Thank you Gregory

[@sweetmask1690]

Is it working on Google sheet?

[@kamelboukerrou6204]

Great concise and step by steps instructions. Thank you very much.

[@Officeinstructor]

Glad you liked it

[@mohitjagad]

Thank you Nabil for this amazing tutorial.. Thanks for sharing..👍

[@Officeinstructor]

My pleasure 😊

[@DaveBarnes-s2r]

After a few glitches I got it to work. I was trying to put days of the month, which excel automatically turns into a date, that cannot be a sheet name (no / allowed ). A couple of extra steps fixing the list and changing it to text and bingo 35 sheets done and rolled over for another month! I think I watched another of your videos for making a totals page from a range of sheets, so there was a "first", "Last", "totals" and "rename sheets"

[@michaelshultz5584]

Thanks - Enjoy your clear explanation of all the details

[@poojakhedekar2851]

I am copying multiple sheets in one excel and want rename it.. but due some restrictions I am not supposed to have macro in that main excel sheet.. is there any way that I can have this macro in another workbook and it will rename the sheets in the main excel sheet automatically...

[@suatalturk3639]

great thank you so much, i helped me a lot with a workbook with more than 200 sheets :)

[@Officeinstructor]

Glad I was able to help...

[@janathenaariana574]

sir @officeinstructor the exercise file is not found.

[@kadirdurma]

You are great man!! it was extremely helpfull and thanks for quick codding tutorial.

[@Officeinstructor]

You're welcome!

[@KeaYeshua]

An excellent video, explained with much clarity and passion, thanks

[@1pieceluffy1]

i want to start the renaming on the next sheet, not on the same sheet. What should I modify in the code? Thanks

[@brodiesammy771]

hi works great but if you want to update say 5 name out of 100 as soon as the macro hits a sheet name which is the same as it is trying to change it to it stops and errors out.. how can I fix this

[@njg5942]

Worked for me - excellent, thank you.

[@Officeinstructor]

Great to hear!

[@ericyeargain6559]

What about if you are wanting to do a Date format? I'm failing with this. If I put in alpha characters only it works, but nothing with a date

[@raghavendranl]

Thank you sir, really it is great class for me. Sir, what steps in same situation in Google spreadsheets? Please guide me.

[@fiteboss]

Great instructions. Thanks!

[@gerardo8229]

What if I want to hyperlink at the same time? Thanks the video it's very helpful

[@Officeinstructor]

You can... watch my other videos about Extracting a List of Sheet names and hyperlinking them

[@kirandeepchoudhry9232]

Awesome way of explaining

[@Officeinstructor]

Thank you

[@eyestickfpv]

What a fantastic video! Could you provide me and advice how to limit to 30 caracters? I have a list taken from an other cell and it’s more than 30 ( limit for sheet name)

[@albertwilson3396]

I have 12 cells I want to name 12 of the sheets (not all sheets just 12 in the middle of 24. and Cells are spread over 4*3 layout. Cells H5:K8) any thoughts?

[@madeleinemoorcroft7601]

I've done exactly what was showed in the video which works perfectly however the other formulas I had in my main sheet now shows BLOCKED what does this mean and how do I get around it?

[@donm1612]

Very helpful. Thank you!

[@Officeinstructor]

Glad it was helpful!

[@Luciano_mp]

Amazing, very helpful. Thank you Nabil!

[@Officeinstructor]

Thank you Luciano

[@milburngrimes5070]

This an excellent video, Nabil. I always wondered how to switch from one sheet to the next in order to change the names, and this is a fabulous workaround! As a language teacher, VBA makes me a bit nervous because I'm always worried about spacing, capitalization, and syntax - the same as I would while teaching composition. How do I learn the rules for VBA spacing, capitalization, indentation, etc? Keep up the fantastic work, Nabeel!

[@Officeinstructor]

Thank you for the nice comment... Did you Subscribe to my Channel? The Best Is Yet To Come

[@sandipmakwana6462]

sir suppose i have list 15 name of sheet so please make vba code to creat sheet as per list if possible

[@ShaibulHoqueMozumder]

How to change one or moreTabs name or worksheets name in upper Case by vba? my worksheets has 100 nos

[@ShaibulHoqueMozumder]

Thank you sir from india

[@nattroy891]

I don't know if you're still checking comments. I put your code into my VBA exactly as you had it, but when I click 'Run' nothing happens.

[@Officeinstructor]

may be macros are disabled

[@ShaibulHoqueMozumder]

Sir it is unable run in excel 2013 , what we have to do? Plz help

[@maheshbhardwaj798]

Amazing, you saved my lots of effort hurs.

[@MohAboAbdo]

Thank you so match, Sir.

[@Officeinstructor]

Always welcome

[@sherlock3293]

Thank you very much, Sir!

[@shivaprasaderram8978]

Thank you so much this was helpful

[@emgraves2310]

Absolutely AMAZING! Thank you :)

[@efiratcan]

THAT IS perfect... thanks a lot man.

[@gmartinez101]

Thank you for sharing this, i have been looking to use this function for a week. It works great

[@verofficials]

Amazing video

[@joaocalunga2016]

Dear many thanks

[@shajupaul5338]

Amazing work.

[@Officeinstructor]

Thank you Shaju Paul

[@rafaelty6285]

Amazing!

[@Officeinstructor]

Thank you! Cheers!

[@dbacker]

how do i avoid name is already taken error? I want the name to be replaced even if the sheet name is already the required name.

[@karunakardev980]

interesting and timesaving video thanks a lot.....

[@Officeinstructor]

You are welcome

[@c07072012c]

How can we make it so that it skips sheets with the name already taken and not give an error

[@LindaWhite-jc9rg]

Can you see me the code for this? Many thanks

[@subratadutta4562]

Nice one

[@mashukanam]

Thank you bro

[@nguyenhoangphuc7555]

thank for you

[@Officeinstructor]

Thank you too

[@mohamed.montaser]

if i want to skip the first sheet and start renaming from the second sheet, how to do it?

[@Officeinstructor]

You need to wrap the looping in a conditional statement

[@mohamed.montaser]

@@Officeinstructor i don't get it

[@khemrajrana7322]

Thanks sir for file & u r amazing sir

[@Officeinstructor]

Thank you for the encouragement

[@incognitootingocni4743]

Thanks so much!!!

[@sandipmakwana6462]

Super and easy

[@Officeinstructor]

Thank you 🙂

[@MrLeecavturbo]

i get an error if the cells contain anything other than letter text. i.e a date or number

[@taizoondean689]

Thank you

[@stevennye5075]

well done!

[@satishchaurasia84ya]

Wow nice trick thanks allot

[@Officeinstructor]

Glad you liked it

[@syednabeelali4823]

Excellent

[@Officeinstructor]

Thank you so much 😀

[@christinacoleman1138]

It keeps throwing an error on "Sheet.Name = Cells(i, 1).Value"

[@chantallecompte5657]

This only worked for the first 5 names, I have 45 names. My first name starts at A4, my i value is 4, right?

[@Officeinstructor]

any code needs customization according to the work situation. I am just explaining a concept

[@sometrioeng2602]

it is great, sir

[@NTECH_e-learning]

how can i rename a group of 10 sheets (middle) in a workbook

[@Officeinstructor]

You need to customize the code

[@ktimilsi]

@@Officeinstructor I came across the same situation. I have close to 200 sheets, and I only want to rename the mid 20 or so sheets. How do I customize the code to get this working?

[@chantallecompte5657]

my first tab changed to 9176?? why?

[@SanviPatil2019]

Amazing

[@vijaysahal4556]

good 👍👍

[@Officeinstructor]

Thanks

[@suhailnbd]

Very nyc

[@Officeinstructor]

Thank you

[@eddiemendez4766]

did not work for me. I do not want to rename the tab that has the naming structure or the tab that has the summed up data but instead rename the remaining tabs. for example i have the first tab that will have the collected data represented and then the next subsequent tabs broken down by the day of the month for the entire month.

[@AhmedAbdalalim]

Great

[@KaelNL]

Why "dim i" and not "dim Sheet"? Seems sloppy. I would prefer to use Option Explicit and declare both variables

[@carlosgranah]

If you are using Option explicit add this Dim Sheet As Object

[@garywenger5209]

I have followed your video several times and have even copied your code for my workbook but it will not work. I have a workbook that is called "Mixed poker rooster" that keeps track of poker players for our bowling league. It consists of a master sheet that tallies weekly deposits. The sheets are named for the day of the week for 35 weeks. IE master, 02-sep-2019, 09-sep-2019, etc. for thirty - five weeks. the statement "Sheet.Name = Cells(i, 1).Value" never gets run. Here is my routine; Sub RenameSheets() Dim i As Integer i = 1 For Each Sheet In Sheets If Cells(i, 1) "" Then Sheet.Name = Cells(i, 1).Value i = i + 1 End If Next Sheet End Sub

[@karmen1061]

Hi , would like to ask how to save can use this marco for everyday . ?

[@sushmitashettigar]

What if present name and changing name of some sheets are same. I am facing this problem getting debug message that try other method present name is same

[@joaocalunga2016]

Dear many thanks

[@leomason15]

Amazing!