![]() |
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