I'm trying to create an invoice tracker and make it easy for the person who will be using it. I know that they can simply see the number above and manually enter the next number in the blank cell below, but then that wouldn't make it magical!
I'm trying to get excel to insert the next sequential number in a specific cell that you click on, based on the cell above.
The tricky part is that it's not a 'standard' number.
We track our invoices based on two digit year prefix (13-) first then the number.
so starting in B4 the first entry would be 13-0001. This would/could be entered manually,
then if you click in B5 excel would input 13-0002,
then if you click in B6 excel would input 13-0003, and so on.
We number our invoices with four digits after the year prefix, as we never make it past 9999 invoices in a year.
To complicate it more, I would like it so if Jan 1, 2014 we start a new file, then the numbering would have a (14-) prefix.
We would/could manually enter 14-0001 in B4 and the rest would be automatically inputted by excel when the next blank cell below is clicked.
So basically, the code or number format can't be restricted to (13-) only, excel would have to read the value above and then increase by one keeping the same prefix. I don't want to have to change the code or formatting every year.
Does this make sense?