• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamically change excel sheet names

T

thong

Member
Hello All,

Is there a way that I can change the name of my excel sheet dynamically?
I want to grab only my Lot Numbers.

I want the sheet name to change dynamically based on B1 & C1 Lot Numbers
 

Attachments

  • Book2.xlsx
    9.6 KB · Views: 4
Hi vletme,

Thank you so much, I really appreciate it...Could you please tell me your secret on how you did it.
 
thong
I solved B1-Lot-number.
I added to it " vs "
I solved C1-Lot-Number
I added it to end of previous result.
I updated with it activesheet's name.
 
Hello,

This is a follow up regarding my above post. I tried to play with the code but it will not work with my attached file.

I would appreciate if someone could direct me so that I can change dynamically my sheet names.

Please find attached file that Im working.

Thank you.
 

Attachments

  • Book2.xlsb
    16.4 KB · Views: 5
thong
Your newer file has formulas in those B1 & C1-cells.
The original file don't have!
And
my version works then
You change B1 or C1-cells values FROM that sheet (now 12K012 vs 15K022),
it won't work if You 'change' one or both of those from other sheet
as You have changed Your case.
 
Hi vletm,

Thanks for the reply. I would appreciate if you can make a work around on your code to suite my case.

Thank you so much.
 
You must log in or register to reply here.
Back
Top