Help with Interesting vlookup, please

  • Hi!


    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/


    Thanks!


    P.S. DUMMY DATA IS USED TO PROTECT CUSTOMER INFO.

  • Re: Help with Interesting vlookup, please



    Very simplistic code as an example. You should add column headers in row 1 so there is something on the Invoice History sheet to start with. Also, there are some rows that have been blanked - you should physically delete everything except row 1 before using as UsedRange is a little fiddly. You might prefer to use a more robust means of finding the last row.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!