I need a script which will do the commands below on a CSV file called exportLabels. The filename is always the same and it would be good to have a script which can run by double clicking a shortcut in the same directory as the file and it then creates a new file called [url removed, login to view] with the modified data. Using Windows 7 and currently using powershell to do something similar but you can use a macro or anything else which will do the task.
A sample file is attached. The number of rows is different every day.
The script needs to do the following:
If cell D1 = XS and B2 is less than 0.501 then change B2 value to X1 else do nothing
Copy Value from AE to AN
Repeat for the rest of the rows
24 freelancers are bidding on average $36 for this job
Sir, Consider it done. You will keep this script in same directory of exportLabels.csv. Just click on it, It will generate the [url removed, login to view] with required data. -Russel