I have an excel spreadsheet that we fill out for delivery notes.
Sometimes we forget to manually change the delivery note numbers and end up duplicated numbers.
I've never created a macro before but I was wondering if I could install a counter on the spreadsheet
However I am not sure if this is the right thing to do as it wont be automated.
So am i better off creating a database, this may be a little more complicated to set up but then I can link my client details, product details and never have a duplicate delivery note number.
Advice on this would be appreciated.