This may be a bit of a stretch. I was thinking about an idea to duplicate a tab an x number of times based on a range of data. at the same time, the tab names would get renamed to match one of the data cells. I attached a spreadsheet to show the idea, if possible.
Please clarify your Excel verion, as there is no 2022: do yo have Excel 2021 or Excel 365? Please update yoyur profile accordingly.
To get worksheet tabs renamed automatically, you'd need VBA. In fact, you'll need VBA for all of this - shall I move the thread for you?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
This is 365
Thank you - then you need to update your profile to include 365 for clarity, please. Do this now.
Shall I move this to the VBA section for you?
Yes. Thank you. i will update my profile.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks