@@ExcelDestination Hi mate, sorry to ask. If you have time, could you please be so kind to write code to rename multiple sheets in a separate workbook? I have the "Master Sheet" in one workbook but the worksheet names to be updated (ie Jan to Oct worksheets) are in another workbook. I am trying to update your code to make it work but I am failing miserably - I am too much of a novice. The workbook with the Master Sheet and the workbook with the Jan to Oct worksheets will be open at the same time.
Awesome video, learned a quite a bit. I have a situation where, I would only like to rename certain tabs, not all. for eg, I have 100 tabs, and I would like to rename tabs 26 through 56. How do I modify the code to do that?
Love this video. Could you possible tell me what code I would put for the command button to rename multiple tabs from a row of data? For example code from a1 to a22 and want to rename the tabs on the bottom each tab for each cell. (another example) cell a1 =Bill a2=Steve so on when I hit the command button it would then change sheet1 to Bill, Sheet 2 to Steve and so on up to a22. The main sheet is called Setup and the second sheet is PasteStatsHere don't want to change that name. Can this be done?
Thank you for this tutorial very informative for someone new to VBA like myself
Glad it was helpful!
You are a champion. This is the code I need. Thank you SOOOO much :-)
You're welcome!
@@ExcelDestination Hi mate, sorry to ask. If you have time, could you please be so kind to write code to rename multiple sheets in a separate workbook?
I have the "Master Sheet" in one workbook but the worksheet names to be updated (ie Jan to Oct worksheets) are in another workbook.
I am trying to update your code to make it work but I am failing miserably - I am too much of a novice. The workbook with the Master Sheet and the workbook with the Jan to Oct worksheets will be open at the same time.
Thank You So Mutch, Sir.
Thanks! 👍👍
Awesome video, learned a quite a bit. I have a situation where, I would only like to rename certain tabs, not all. for eg, I have 100 tabs, and I would like to rename tabs 26 through 56. How do I modify the code to do that?
Love this video. Could you possible tell me what code I would put for the command button to rename multiple tabs from a row of data? For example code from a1 to a22 and want to rename the tabs on the bottom each tab for each cell. (another example) cell a1 =Bill a2=Steve so on when I hit the command button it would then change sheet1 to Bill, Sheet 2 to Steve and so on up to a22. The main sheet is called Setup and the second sheet is PasteStatsHere don't want to change that name. Can this be done?
❤
This is great. Could you explain this in english please.
thank you sir really helpful video
Most welcome
Can I ask if the column "Current Name" is a number, it can't be changed?
Excellent !!!
Sir Make More Videos.
Upload 1 or 2 Videos daily.
Tnx.
Thanks.........I wish......I can.
@@ExcelDestination Waiting...
wow 👍🏻👍🏻👍🏻👍🏻
Thank You!
Thanks for sharing video
Hi , would like to ask how to see for i = 1 to a , and for j . Need to see which column ?
Keep come all error , ‘ run time error ‘9’ subscript out of range
Each separate sheet should be saved according to the year of the student's name in the excel sheet