I use Excel for my Invoices and most all business info handling.

I use a unique type of Invoice / Job #. It is formatted like this: 06-001-01.
The "06" is the year. The "001" is the day of the year (001 - Jan 1st / 365 - Dec 31st). The final (2) digits "01" are the Job# for that day. (At this point I only need 2 digits, 01 - 99 jobs per day).

The number generated by the date 01/01/2006 is "06-001" (cell I17), then I have to change the "01" manually (to other numbers as needed) which is in cell (K17). BTW: (I17 & J17) are merged for a wider cell space.

When I select the cell that contains the date (B19), then press ( Ctrl & : ) it inserts todays date, then job number/date code are automatically generated.
However, the last 2 digits have to be manually changed.


What I want to do is:

1) Have last (2) digits "01", become sequential, automatically, each day. (No dup invoice numbers). Each "Save" will increase it by 1. (01, 02, 03, etc).

2) Use invoice number as worksheet filename, when saving.

3) Place a "Save" button on the worksheet. (when clicked, it saves using the invoice number.

If anyone can help with any part of this, I would greatly appreciate it.

I had another issue, but couldn't get an answer for that one. I will try that one again, later.

If you like challenges, I have a few more, after these.

Thanks,

Harv