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.
|