Let's say I have an Excel Workbook with 3 sheets, Sheet1, Sheet2 and Sheet3.
If I delete Sheet2, I am left with Sheet1 and Sheet3.
Is there any way of automatically renaming worksheets, so that if I delete a worksheet somwhere in the middle, the remiaining worksheets automatically rename themselves consecutively?
If I delete Sheet2, I am left with Sheet1 and Sheet3.
Is there any way of automatically renaming worksheets, so that if I delete a worksheet somwhere in the middle, the remiaining worksheets automatically rename themselves consecutively?