Sign in with
Sign up | Sign in
Your question

How to create counting numbers in EXCEL 2013

Last response: in Apps General Discussion
May 6, 2014 5:15:45 AM

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.
May 6, 2014 5:26:11 AM

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.
May 7, 2014 6:22:17 PM

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?