Hello Gurus,

I have figured out a simple way of creating sequential invoice numbers by creating a macro which simply copies the value of "1" & paste special/values/add this to existing number ie 1000 creating 1001 which is then "paste special" into the destination cell on invoice.

This creates a rolling shedule ie next time it becomes 1002 etc.

This works fine except that this "source" numbers register needs to be located in a separate spread sheet to the destination to make sure this system is not corruptible. The reason for this is I may be saving several copies of the invoicing spreadsheet as different client job's in progress, & I don't want to end up with double up invoice or quote numbers, hence for my...