Hi there everyone!
I'm helping a friend sort out her invoicing and sales ledger as a favour, but just discovered how rusty I am! I've set it up so that she can fill out an invoice and click a button, and the invoice number, customer details, figures etc are added to her sales ledger and the invoice resets with the next invoice number. So far, so good.
What I can't figure out is this. SKU codes are in B18 to B27 of the invoice, and quantities in G18 to G27. On the sales ledger her SKU codes appear across X3 to GG3, and I somehow need to get the quantity information for the SKU codes onto the sales ledger on the same row as the other invoice information. I used an integer called NewRow to select the row for that information.
I've tried looking at HLookup/VLookup but I've never used them in VBA and my brain is hurting. Any ideas anyone? My current macro looks like this:
Thanks, ChrisPlease Login or Register to view this content.
Bookmarks