HI. I need a code to change cell value when year starts. Its for my invoice number. For example: for the year 2012 I start with invoice number 1 and i'm making invoices 2,3,4..., but when the year ends I want the number of the invoice to start from 1 for the next year. Any ideas?
Thanks.
Update a cell when year ends
-
-
Re: Update a cell when year ends
You could do it with a formula. This is obviously a very simple, quick example...but it could be modified for about anything.
-
Re: Update a cell when year ends
The example I gave was just a quick way to make a list. Instead of more guessing, maybe post your workbook so I can see how it's set up
-
-
Re: Update a cell when year ends
forum.ozgrid.com/index.php?attachment/44898/
I've made a few changes, but I'm still not sure if it's going to help you.
I made column F in invoice list to create numbers automatically based on the date in column E. Then column C takes the same number as column F and the invoice number on the "invoice" finds the last number in column C and adds 1 to it.
Let me know if that's even close, or if I'm way off...I'll try something else
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!