Forum Discussion

jkpanic's avatar
jkpanic
Copper Contributor
Oct 16, 2019

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...
excel
jkpanic's avatar
jkpanic
Copper Contributor
Oct 16, 2019

Subodh_Tiwari_sktneer 

 

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