Dear all,

Please I am new to this forum the site is still strange to me.

I need a macro that on invoice template will add new invoice with number MIL-EI-0001 and on, and then paste specific data of the invoice in invoice register with the invoice number hyper linked and clear specific data in the invoice template.

Best Regards,
Daotor.