Hi, I am in need for someone to write a script or macro to modify data in my csv.
Basically, the csv has about 20k records with several columns and it changes all the time.
The macro/script will do this:
1. look at the data on columnB
2. if it sees value "xyz" on cell B1 it will create 3 cells - G1,H1,I1 with different values.
B1="xyz" will generate G1="ABC", H1="123", I1="RED"
B5="YELLOW" will generate G1="999", H1="SKY", I1="KEVIN"
3. If the script can't find any of the given values it will just continue until it finished examining the data in the given column.
[url removed, login to view] the new csv as [url removed, login to view] (so the original file stays the same)
It is important that once I set the data once I can run the same script/macro unlimited times at the push of a button without the need to set it again everytime.
It is important that I will be able to modify the values and columns for input and output.
It is important there will be NO errors. whatsoever.
It is important that I can load the values from a txt file as there are many.
It is important that it will be easy to use and change.
Please don't waste my time with pm's etc.
It's either you can do it or not. if you can, name your price and tell me what or how you can do it, if there's a need for a special app or not...