Hi there,

Thanks for coming back. All the information I have provided is made up but format wise is 100%. Actual report is over 2800 lines

1. There is not real significance with NSW. (FYI, NSW is a state in Australia) I have included as there are some companies with inclusion of symbols (e.g. " - " " () " ..etc)
2. The export can vary each month. (e.g. Additional/deduction company name, additional/deduction product, additional/deduction product range) but format wise it will still be the same.
3. The report is standard, but with inconsistent programming. What I can distinguish is:

Product total ends with - "Total for :" (no space after colon) followed by product name
Company total ends with - "Total : for " (space after after for) followed by company name

I am currently attempting to do a loop ( Do..if.loop until Grande Total: ).. but a bit tricky.. so trying to find my way around it. Let me know if I am using the right technique. Was not expecting this to be that difficult. Any guidance would be great.

Thanks