...I don't know how. I need some help automating a spreadsheet I use in my office. I can work my way around excel pretty good, I just don't know the programming for what I want. This form is for keeping records of invoices and assigning them P.O. (purchase order) numbers.

The first cell would need to populate the date, but only if there is going to be information in the rest of the row.

The second cell would need to count and display the next number in a sequence. It's a 9 digit sequence. The first 3 numbers will never change, then a dash (-), the next two numbers would only change once a year, ex. (08), another dash (-), then a set of 4 digits ranging from 0001 to 9999. This 9 digit sequence is the PO numbers.

Also I want to add a "clear" button so that the form can be reset for new info.

Pull down menus would be nice to add also, but that may more than what I can hope to get done.