We are looking to get an Excel Macro built that will take our shopify export file and clean the data up where we can work with the data into other product catalogs.
Scope of Work:
We need this to be coded in VBA for Excel 2016 and when we open the workbook it will do the following:
1. Browse for the CSV or workbook to transform
2. Run the Script
3. Save the transformed file into the same directory with a “-transformed” appendage to the file name
I have more detailed examples in a docx and sample csv file attached.
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy