I have 12 rows of data in an excel file . There is a distributor code in the first columns. There are 4 distributors in the 12 records , each having 3 records each. One of the column also has the email ID of the distributor. I want to select the 3 records of invoices outstanding for each distributor and sending them reminder through email by copying the entire record of the row ( effectively 3 records in 3 rows) .
I tried the Do While method to read each record based on the distributor code in A1 , A2,A3 but not able to break the loop at A4 since A4 starts with a new distributor code. I want to extract the three records of each distributor , paste them in a separate Excel File , save it as PDF and send to the distributor . The records which I want to read and save in a separate File reads all the 12 records instead of just the 3 which has a common distributor code or ID . How to resolve this