Excel VBA export data from a large csv file into another csv template based on the values of some columns
Budget: €8 – €30 EUR
I have to daily upload one csv file "PRODUCT FILE" to a store "UPLOAD FILE".
For that I need to automate the process: grab some columns from the "PRODUCT FILE" and export the data from some columns to certain columns in "UPLOAD FILE". For example: Column A from the "products file" goes to column C from the "UPLOAD FILE"...D goes to C....
Also, before exporting from the "products file" to the "UPLOAD FILE":
- I should have the option to apply profit margins (10%, 15%, 20%, 25%, 30%, 35%) to the original price that exist in "products file" and the exported values should have a comma (,) and not a dot (.);
- Before export, the reference to "vidaXL" should be removed and replaced by a blank space;
- Before export, the divider for categories " > " (space > space) should be replaced only with ">". Example:
SOUND > Headphones GOES SOUND>Headphones
PLEASE: When applying make the reference: AUTOMATE
For that I need to automate the process: grab some columns from the "PRODUCT FILE" and export the data from some columns to certain columns in "UPLOAD FILE". For example: Column A from the "products file" goes to column C from the "UPLOAD FILE"...D goes to C....
Also, before exporting from the "products file" to the "UPLOAD FILE":
- I should have the option to apply profit margins (10%, 15%, 20%, 25%, 30%, 35%) to the original price that exist in "products file" and the exported values should have a comma (,) and not a dot (.);
- Before export, the reference to "vidaXL" should be removed and replaced by a blank space;
- Before export, the divider for categories " > " (space > space) should be replaced only with ">". Example:
SOUND > Headphones GOES SOUND>Headphones
PLEASE: When applying make the reference: AUTOMATE