I have a customer who uploads files to their system using CSV files which they are send from certain suppliers. The system rejects them if they are in the wrong format and they now have a new supplier sending their own style of CSV output. What I need to find out is how I can automatically parse the CSV file and copy the correct columns from their CSV into the right columns on the new CSV. The new CSV file they recieve has all the data needed but just in the wrong places.
I think a macro of some sort would do this in Excel but I know very little about them?
Any ideas.. this must be a fairly simple thing to do (I Hope)
Thanks in advance