Hello,
I am new in Excel VBA. So I will need yr. expertises and helps. Thanks in advance.
Every day, I receive a bulk XLS file containing bulk invoices. The bulk invoice containing more than 500 invoices which we ship to different stores. I would like to extract individual invoice base on First Row VALUE (CUSTOMER NAME) which repeat for each individual invoice and base on the last row of the invoice which are 3 BLANK ROWS. The extracted data will be paste on NEW worksheet and then PRINT using a SPECIFIC PRINTER & SPECIFIC TRAY. The below is how is look likes
A1
CUSTOMER NAME
DATA
DATA
DATA
BLANK ROW
BLANK ROW
BLANK ROW
CUSTOMER NAME
DATA
DATA
DATA
BLANK ROW
BLANK ROW
BLANK ROW
This is urgent, so any input is very appreciated.
Regards,
Bookmarks