I have an excel workbook 'managing' invoices for me.
I know Access would be better, but for various reasons it has to be Excel for the moment.
I have a macro which increments an invoice number and saves a PDF of the invoice.
I would like to populate two columns on a worksheet within the workbook where it keeps a record of the invoice number and the total amount it was raised for.
Could anyone help me achieve this? forum.ozgrid.com/index.php?attachment/46049/
P.S. DUMMY DATA IS USED TO PROTECT CUSTOMER INFO.