Forum Discussion
jkpanic
Oct 16, 2019Copper Contributor
Alphabet sort and worksheet sort
Hi, I have a workbook with multiple worksheets and was kindly given some code that enables me to type a name in worksheet 1 (called Training Matrix) and this will change the name on the worksheet...
jkpanic
Oct 16, 2019Copper Contributor
Hi,
Thank you but this does not quite achieve what I want. It creates the worksheet with the new name but does not delete the worksheet or the worksheet name if I delete it from "Training Matrix".
Also if I add a name to the bottom of the list on "Training Matrix" and then sort alphabetically it does not reorder the worksheets alphabetically, is this possible?
Cheers
Julian
Subodh_Tiwari_sktneer
Oct 17, 2019Silver Contributor
Hi Julian,
Sorry, I missed that requirement.
Please test the attached and let me know if it works as desired now.