I have to download a .txt file from Amazon which has Date, Transaction type, order id, product detail, total product charge, total promotional rebate, Amazon fee, other and total.
I just need the total product charges.
With this being just a .txt file I can separate the columns correctly, delete the columns I don't need, then filter on Product Charges - I then put a formula to total the amount.
I need to do this each day. Is there anyway I could automate this procedure using Excel.
ps I cannot attach the file as it has customer ids in.