How to create counting numbers in EXCEL 2013

tagsalot

Estimable
May 6, 2014
2
0
4,510
I need to create counting numbers that continue over to each worksheet in a workbook. For an example I need to recreate PO#'s in a workbook. Every time I hit the "+" it creates an empty worksheet. I have to copy and move from an existing worksheet which then will not recreate my Dates or PO#'s. My PO #'s also have a dash "-" in them: example: 10-001 and so on.

I need to find a solution to this problem if anyone is able to help or entertain me with ideas. Thank You.
 
Have you ever worked with macros? If so, you can try creating a macro that runs when you create a sheet, goes to a master sheet to increment and fetch the number, and paste the result into the new sheet.

Just keep two separate numbers and have a cell that's formatted with the concatenation of 10, "-", and 001.
 
How many sheets you plan yo have by placing every order in separate sheet?
Altough Excel does not have a limit on them, after a dozen or two it will start lagging, not to mention that navigating it will be a nightmare.

Why not look at some software made for store front / back office?