Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate Order worksheet from Quote worksheet | Excel Worksheet Functions | |||
Insert New Data in Order on an Existing Chart | Excel Discussion (Misc queries) | |||
When I insert a hyperlink in excel in order that it opens an imag | Excel Discussion (Misc queries) | |||
Worksheet 1 exact copy of worksheet 2, but in different order | Excel Discussion (Misc queries) | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions |