I have two files that i need to have merged together and data formatted properly for CSV import. There are a few tasks that need to be done and I will explain them here:
1. In main file (Product Export) , write a Macro to clean up UPC Field ( currently has extra digit and some spacing that neds to be removed it currently looks like this 0 83000 00116 1 and it should look like 83000001161
2. In the Category field, We want to Add 1 brand to all categories. ( So that will need a Macro as well)
3. In the Cross Sell column, we need to add the Cross - Sell UPC's as defined in the 2nd sheet (Similar Items .xlsx) The logib will be match the UPC (already fixed in step 1) then add the 3 upc's from the cross sells listed in sheet 2 (separated by acomma)
4. Save as CSV for import .
5. the job will be considered complete when an import is done succesfully.
6. I will be available on chat to walk thru this with you .
14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi there, Lets discuss more on chat. Relevant Skills and Experience I am an excel/word/outlook VBA automation professional having 7+ years of experience. Thanks Aman Proposed Milestones $35 USD - 1
Sir, I have a Question. Could you Answer that? Relevant Skills and Experience I will show sample. I am a Professional Freelance over 3 years experience. Thanks Proposed Milestones $30 USD - xz
sir I want to work for you ,, thanks :) Relevant Skills and Experience Data Entry, Data Processing, Excel, Excel Macros, Excel VBA Proposed Milestones $15 USD - Merge Excel Products files
Part time data entry operator Relevant Skills and Experience microsoft office typing speed of 70-80wpm Proposed Milestones $30 USD - completion of data entry project