Can an expert help me out with VBA code that will split out the info I need please.
I have a large CSV file in this format
Cat Reference W/Held COI Tax W/Held B/U Tax Charges Tax Deducted Type Admin Net Amount Amount to Client
PKNHL0002 (111) CHTY HTCU-AMPHLETT SCHLR(WAAA)
Grp1 5860.0000 0.00 0.00 0.00 0.00 666.90
ASHBY0014 (111) CHTY HTCU-ASHBY A J H W/T(WSSS)
Grp1 3788.0000 0.00 0.00 0.00 0.00 431.09
I am not bothered about the headings, what I need to end up with this
I have tried Text to column but this does not work [for me]
There are over 5000 lines in the CSV file and each time there is a GRP1, to the right is the amount and above that is the data I need.
All data is in column A