I need a global find and replace. Easy to use macro for the windows 7 (non advanced) version of excel.
I have 1 csv file downloaded from amazon which changes name daily.
need to change the amazon provided column/field for sku. To my own relevant info...
To do this I keep a seperate excel file with two colums 1st column field to be replaced example 26-S04D-GCOU in the second colunm data to replace it with example. SP-1-JtBlk.
I need 2 sreadsheet solution so I can update any new changes or conversions
Possibility of more work after this job.
I know my IT so i've got a good idea of excatly how actual work this will really take so reasonable quotes please.