ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   insert worksheet order (https://www.excelbanter.com/excel-worksheet-functions/173975-insert-worksheet-order.html)

clint24

insert worksheet order
 
I am trying to set up a workbook to inventory our SCBA bottles here for the
fire department and am having some issues. Here's what I would like to be
able to do, don't know if it's possible, but here it is:

The bottles are numbered 1-357 and I would like to be able to insert a new
worksheet, have it insert on the right (not the left) of the previous
worksheet, and have it automatically number itself sequentially. My problems
are that everytime I insert a new worksheet it appears on the left of the
previous worksheet and I have to rename the sheet everytime to the number on
the bottle (ie.- from 'sheet 1' to 1, 'sheet 2' to 2, etc). Any help would be
greatly appreciated. Thanks.


All times are GMT +1. The time now is 02:52 PM.

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