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, merge excel files file, 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, remove duplicates merge excel files, merge excel files remove data, merge text files based common field, vbscript merge excel files

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

Projektin tunnus: #15444953

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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ä
(249 arvostelua)

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ä
(162 arvostelua)

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ä
(111 arvostelua)
$100 USD 1 päivässä
(15 arvostelua)

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ä
(16 arvostelua)

Immediate [login to view URL], 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ä
(28 arvostelua)

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ä
(26 arvostelua)

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

$25 USD 1 päivässä
(8 arvostelua)

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ä
(2 arvostelua)
$25 USD 1 päivässä
(2 arvostelua)
$25 USD 1 päivässä
(0 arvostelua)

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)

A proposal has not yet been provided

$15 USD 3 päivässä
(0 arvostelua)

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)