Find Jobs
Hire Freelancers

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 .
プロジェクト ID: 15444953

プロジェクトについて

14個の提案
リモートプロジェクト
アクティブ 6年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に14人のフリーランサーが、平均$40 USDで入札しています
ユーザーアバター
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
7.4
ユーザーアバター
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
6.4
ユーザーアバター
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
6.3
ユーザーアバター
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
4.5
ユーザーアバター
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
4.0
ユーザーアバター
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
3.0
ユーザーアバター
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
0.0
ユーザーアバター
A proposal has not yet been provided
$15 USD 3日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
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日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Lyndhurst, United States
4.9
84
お支払い方法確認済み
メンバー登録日:4月 18, 2007

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。