I am trying to create invoices n Excel that will insert a unique reference
number each time thetemplate is opened.

I am not sure which function will work for this application, or whether I
need to create something in visual basic.

Has anyone got any suggetions?

Thanks

David