ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I change the number on copy sheet so I don't have to renam (https://www.excelbanter.com/excel-worksheet-functions/40407-how-do-i-change-number-copy-sheet-so-i-dont-have-renam.html)

crystal

How do I change the number on copy sheet so I don't have to renam
 
In Excel -- When I use the copy sheet feature in this particular workbook,
instead of increments of one, the new name comes up as the old sheet numb (2)
or the old sheet number (3). I have to rename every sheet. How can I change
the sequence so I get numbers 1, 2, 3, etc.


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com