Käynnissä

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

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 .

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Excel Macros, Excel VBA

Näytä lisää: indesign data merge tutorial, indesign data merge excel, indesign data merge catalog, indesign data merge there is at least one data placeholder, indesign data merge multiple records, data merge indesign cc, indesign data merge images, indesign data merge empty field names, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, add upc field zen cart, merge excel files common data, merge excel files remove duplicate, merge excel files duplicates, merge excel files using vbs, script excel merge excel files

Tietoa työnantajasta:
( 70 arvostelua ) Lyndhurst, United States

Projektin tunnus: #15444953

Myönnetty käyttäjälle:

Wasifsgd101

This project is about data cleanup and merge 2 excel files in one as per instructions. Relevant Skills and Experience I have incredible skills for EXCEL and I am ALISON affirmed for EXCEL. Proposed Milestones $14 USD Lisää

14 $ USD 0 päivässä
(14 arvostelua)
4.1

16 freelanceria on tarjonnut keskimäärin 40 $ tähän työhön

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 Lisää

100 $ USD 3 päivässä
(171 arvostelua)
7.1
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 päivässä
(133 arvostelua)
6.3
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 päivässä
(97 arvostelua)
6.1
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 päivässä
(22 arvostelua)
3.8
jasalaz100

Immediate [url removed, login to view], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi Lisää

50 $ USD 1 päivässä
(7 arvostelua)
3.0
100 $ USD 1 päivässä
(1 arvostelu)
2.0
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 päivässä
(1 arvostelu)
0.8
imran2093

Hello Sir/Madam, I am able to do this project. I have a similar experience. I will give you exact accurate work within [url removed, login to view] I can help your other stuff. Thank you for your time Relevant Skills and Experience data Lisää

25 $ USD 1 päivässä
(1 arvostelu)
1.0
25 $ USD 1 päivässä
(0 arvostelua)
0.0
25 $ USD 1 päivässä
(0 arvostelua)
0.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 Lisää

10 $ USD 1 päivässä
(1 arvostelu)
0.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 hav Lisää

20 $ USD 1 päivässä
(0 arvostelua)
0.0
Mezan0

Hi,i read through your project descriptions carefully and i can do your job 100% accuracy have lot's of experience about this.i will deliver your job by your require time. thanks Relevant Skills and Experience Animati Lisää

55 $ USD 6 päivässä
(0 arvostelua)
0.0
GurleenDS

A proposal has not yet been provided

15 $ USD 3 päivässä
(0 arvostelua)
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 päivässä
(0 arvostelua)
0.0