Merge Excel Products files - clean up UPC field and add Column with new data

$10-30 USD

Ακυρώθηκε

Αναρτήθηκε

πάνω από 6 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

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 .

Ταυτότητα εργασίας: 15444953

Σχετικά με την εργασία

14 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

14 freelancers δίνουν μια μέση προσφορά $40 USD για αυτή τη δουλειά

@bouslimi1979

Hi, I ll code a set of macros for that .Step 1 is clear. Step 2 : based on what we will add a brand. Step 3 : need more explanation. Thanks Expérience et Compétences appropriées Excel/VBA coder Étapes proposées $100 USD - m

$100 USD σε 3 ημέρες

4,9

(249 αξιολογήσεις)

7,4

@avinav606lx

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

$94 USD σε 1 ημέρα

4,9

(162 αξιολογήσεις)

6,4

@paulmd369

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

$30 USD σε 1 ημέρα

5,0

(111 αξιολογήσεις)

6,3

@HamzaAslamB

I have to merge two files Relevant Skills and Experience Data Entry Excel Excel VBA Proposed Milestones $25 USD - 25 When we start ?

$25 USD σε 1 ημέρα

5,0

(16 αξιολογήσεις)

4,5

@Mahdi0199

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

$15 USD σε 1 ημέρα

4,9

(26 αξιολογήσεις)

4,0

@nwiforemmanuella

I am a data entry clerk and am an expert in the use of excel. I can effect the changes and merge the two files Relevant Skills and Experience excel, data entry Proposed Milestones $10 USD - merging the two files and space removing

$10 USD σε 1 ημέρα

5,0

(2 αξιολογήσεις)

3,0

@mrkongkan

Sir, I have seen your job details and I want to do your job. I have a good skill on data entry as well as MS Excel. Please give me a chance to do it. Thank you. Regards, Mrikongkan Relevant Skills and Experience I have a good skill on manually data entry, MS excel, MS Word, Google Docs as well as web research. Proposed Milestones $20 USD - Merge Excel Products files

$20 USD σε 1 ημέρα

0,0

(0 αξιολογήσεις)

0,0

@GurleenDS

A proposal has not yet been provided

$15 USD σε 3 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@techieworld2017

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

$30 USD σε 2 ημέρες