Hi there to all members of this forum.
There may appear to be a very easy solution to my question but it's really bugging me and so I hope someone may be able to assist me?
I require excel to automatically generate the next invoice number in column 3 after a date and time has been entered in any one of the cells in column 2.
eg.
Stock No. Sale Date/Time Invoice No.
1 03-Nov-20 3:00 PM 2
2 01-Nov-20 1:00 PM 1
3
4 10-Nov-20 10:00 AM 4
5
6
7 10-Nov-20 3:00 PM 5
8 05-Nov-20 5:00 PM 3
9
10 15-Nov-20 12:00 PM 6
I have attached a sample workbook for reference.
Many thanks in advance for any assistance in this matter.
Bobby.
Bookmarks