Help import data into Excel spreadsheet from other spreadsheets

$30-250 USD

クローズ

投稿日:

約5年前

$30-250 USD

完了時にお支払い

I need to import about 7000 lines of data into a larger spreadsheet from a few new sheets. I have a few (2-6) sheets of NEW data and 1 sheet larger that has OLD data. We need to move any of the unique NEW lines over to the OLD master sheet but avoid bringing over any duplicates that are already in the OLD sheet. Basically, we are updating our yearly inventory and need to make sure we are only bring in the rows of data we need and NOT duplicate data that we do not. Looking for someone who is an Excel EXPERT and VERY experienced with using vlookup fuction of Excel. Except about an hour or so discussion ensuring the data is being handled properly. The job is quite simple but very important that it is accurate so we will have to double check everything afterwards. Please specify level of Excel expertise when bidding. Thanks!

プロジェクト ID: 18722946

プロジェクトについて

37個の提案

リモートプロジェクト

アクティブ 5年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

この仕事に37人のフリーランサーが、平均$125 USDで入札しています

@schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

$250 USD 4日以内

4.9

(604 レビュー)

8.5

@deepbluetech

Hi, I have been in the field of Excel automation for the past 15 years and have completed more than 300 projects on Freelancer. I can take on your project and deliver the requirements. Only thing is that there should be an unique column for vlookup. Let me know. Thanks, Arul

$150 USD 3日以内

5.0

(209 レビュー)

7.4

@citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$150 USD 3日以内

4.7

(97 レビュー)

6.4

@macroPOL

Hello, I am Excel and VBA expert. Could you provide sample files? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan

$100 USD 4日以内

5.0

(98 レビュー)

6.2

@vmadhavan15

I am not random bidder.. PLease ping me if you are interested with my prposal and share m ore detail.. thank you..,

$250 USD 3日以内

4.9

(28 レビュー)

5.0

@GabrielBarreiro1

Dear, I am interested in participating in your project. I have experience and skill in data management through Excel. I am available to start immediately, do not hesitate to contact me. Clarification: • The suggested delivery time is indicative. For a correct projection, it is necessary to know more in detail the project and its needs. • For the acceptance of the project, please create the following Milestone Payments: - 20% of the offer. When I sent you a preview of the project I will ask you to release the funds if you agree with the first results. - 80% of the offer. For the complete work. I am serious and responsible with my work, this requirement also demonstrates my commitment.

$100 USD 5日以内

5.0

(28 レビュー)

4.9

@gsanggara

*** I am Excel Expert *** Hi, I am excel freelancer, very interested to work on your project. I have done a lot of excel macro with different2 usage and function. I can create macro to transfer your data from new data sheet into master data sheet whether update existing data or add totally new data in light version to make sure the process fast executed & smoothly. for your reference on my excel ability & Client Review please refer to below link: https://www.freelancer.com/u/gsanggara Please ping me to discuss further. I am available & ready start work immediately. thanks. Best Regards, GS Anggara *** Customer Satisfaction is My "FIRST PRIORITY" ***

$100 USD 1日以内

4.9

(28 レビュー)

4.3

@Altantsetseg

Hi. If you want a Excel macro which "runs through the lines of master sheet and check against the new sheet containing new data and if there is no duplicate, then copy the new line to master sheet"., then its my very experienced area. I have been experienced in programming including MS Excel macro VBA/ since 2000. During 2006-2013, I had been working as a senior developer for Financial system developed in Ms Access which use VBA for coding constantly. If I understand your requirements correct, I can provide you best accurate solution. Hope to hear from you back, soon. Regards, Alta

$150 USD 3日以内

4.8

(6 レビュー)

4.1

@DBoptimizations

Hi, I have about 5 years of professional experience with Excel. Formulas in excel are my biggest strength. I have also done much data cleaning (as data has to be standardized before processing). If you give me that project, I'll make sure that data is treated in the best possible way. I'm an expert in formulas like VLOOKUP, INDEX, MATCH, CONCATENATE, and any other formulas I may use to merge the files. I'll also do data cleaning before merging, if such is needed (I can't say from now as I haven't seen the files themselves). Then I'll double-check a few times. My bid is low only because my experience on this platform is still little. I'm working for better rating now.

$30 USD 3日以内

5.0

(5 レビュー)

3.6

@redoyakond1

I have read your description properly and I am experienced in excel. I understand what to do. Please knock me for further discussion. I am looking forward to hear from you. Thanks

$70 USD 7日以内

4.9

(10 レビュー)

3.3

@dilhanijayarath4

Hi, I'm a recent graduate with some free time. I would really like to be a part of your work. I value the quality of work and also finishing the work on time.

$155 USD 3日以内

5.0

(7 レビュー)

2.1

@liejuni

hi, we could make you the macros, as simple as clicking a single button. this project is about MATCHing new data and old data, where it only recording the UNIQUES new data into old data and merge it, simple way to do it is by MATCH the RANGE and do the LOOP. please contact us on 08.13-82.82-96.98 (WA) and please do check our youtube channel "EXCEL DAHSYAT" for our previous project

$155 USD 3日以内

5.0

(1 レビュー)

0.8

@SteveHeu

Hi This seems like a pretty straight-forward project I've been using Excel for over 5 years in my regular day-to-day job, and have mastered all aspects of its functions, formulas and macro coding This is quite a simple task and I can do it in less than an hour, however if this is a regular piece of work and I can find a faster/easier way to perform this task for you, I'd be happy to negotiate repeat business at a fraction of the price Cheers Steve

$60 USD 1日以内

0.0

(0 レビュー)

0.0

@kdchambers2017

I have vast knowledge of this kind of excel work, I can provide you the desire result within time, Please contact me for further discussion

$55 USD 2日以内

0.0

(0 レビュー)

0.0

@romimardiansl

hi, i have read your project description and i am interested with your project. i am master in excell (advance level). one of my project is create monitoring and evaluation using indicator that need extensive formula, not just vlookup or hloookup as core data define. i can assist you to separate the data and also avoid data duplication. rem9ve data duplication is final step. feel free to contact me regards, romi

$55 USD 1日以内

0.0

(0 レビュー)

0.0

@zliaquat1

Hello sir.. I did mcs recently.. I have grip on Ms office kindly hire me.

$155 USD 3日以内

0.0

(0 レビュー)

0.0

@bleedingedgearmo

in 4 days or less i'd be able to finish the whole requirement. I've been working on a lot of excel files and data entry projects outside of this website.

$55 USD 4日以内

0.0

(0 レビュー)

0.0

@spreadsheetwhisp

I am very experienced with spreadsheets and I have several methods to check for duplicate data. Select my bid, send along the data, and we can go over the plan to make sure everything is done to your satisfaction.

$111 USD 10日以内

0.0

(0 レビュー)

0.0

@sreedhar006

This is a dam easy task I can do this with in a day and also can beautify you excel for data fool proof

$111 USD 2日以内

0.0

(0 レビュー)

0.0

@mansolis2712

I have a lot of experience with excel, in my last job I created a data base just with excel and care about all the data, I am used to this kind of job

$66 USD 1日以内