View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
clint24 clint24 is offline
external usenet poster
 
Posts: 1
Default 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.