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 [url removed, login to view] then change B2 value to X1 else do nothing
Copy Value from AE to AN
Repeat for the rest of the rows
24 freelancere byder i gennemsnit $36 for dette 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