Closed

Help import data into Excel spreadsheet from other spreadsheets

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!

Skills: Data Entry, Data Processing, Excel, Visual Basic

See more: excel pull data from another worksheet, update excel spreadsheet with data from another spreadsheet, automatically import data into excel, transfer data from one excel worksheet to another automatically, how to automatically update one excel worksheet from another sheet, excel import worksheet from another workbook vba, import data from one excel workbook to another, excel import data from another workbook vba, import data excel mysql, paste data excel spreadsheet, exporting data excel spreadsheet quality center, google finance data excel spreadsheet, import data excel file perl, import data excel multiple sheet vba, import data excel quickbooks 2008 invoice, data excel spreadsheet set organization, php import data excel, copy web data excel spreadsheet, mysql import data excel 2007, arena 100 import data excel

About the Employer:
( 0 reviews ) Chennai, India

Project ID: #18722946

40 freelancers are bidding on average $120 for this job

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. More

$250 USD in 4 days
(320 Reviews)
7.8
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 More

$150 USD in 3 days
(209 Reviews)
7.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. More

$100 USD in 4 days
(94 Reviews)
6.0
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 mar More

$150 USD in 3 days
(62 Reviews)
5.5
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 in 3 days
(27 Reviews)
5.0
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 ve More

$150 USD in 3 days
(6 Reviews)
4.0
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 More

$100 USD in 1 day
(20 Reviews)
3.7
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 More

$100 USD in 5 days
(5 Reviews)
2.9
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 in 7 days
(7 Reviews)
2.7
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 th More

$30 USD in 3 days
(4 Reviews)
1.9
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 More

$155 USD in 3 days
(1 Review)
0.8
DrGabo

I have a couple of ideas to address your challenge without using VLOOKUP (I confess that was my first idea): -VB script that visit the lines looking for new records to write them into a output new file -Opening the E More

$55 USD in 3 days
(0 Reviews)
0.0
mailsachin1

I have been working in a leading banks HR payroll dept for 14 + years. Have sound knowledge of vlookup as it is a part of the every day work i do. Assure you that the work will be done with 100% quality.

$98 USD in 5 days
(0 Reviews)
0.0
mnahmed91

I’ve worked extensively with excel and all the advanced functions, especially vlookup, hlookup, macros and vba when working as an analyst. I can import the unique records accurately. I’d love to talk more about the pro More

$150 USD in 3 days
(0 Reviews)
0.0
$222 USD in 3 days
(0 Reviews)
0.0
mi3pranesh

Hi.. I have 8+ years of experience in Excel and I have been into robotics team and can automate all excel related reports, dashboards using VBA and formulas. I have good experience in creating pivots, vlookups, Hlookup More

$222 USD in 3 days
(0 Reviews)
0.0
vivek388

Can be done as fast as possible. A student in Malaysia doing my degree in Software Engineering. This would be really helpful to earn some extra money. This job can be done faster. Thank you.

$155 USD in 3 days
(0 Reviews)
0.0
D0ed

Hello, I believe you must be having unique SKU/PID for each product, which can be used for check (using Vlookup/Match etc functions) between OLD and NEW data before NEW data is moved to OLD data sheet using More

$35 USD in 3 days
(0 Reviews)
0.0
tommy1003

With experiences in Excel, I can help you: - Handle your data as you requested. - Accurate and clean data - Vlookup Function expert - Excel Level: Advanced

$77 USD in 2 days
(0 Reviews)
0.0
hashemmoolla

Hello, How are you? I am Hashem, I am new to Freelancer, however not new to Excel. I am very interested in working on your project. Few details below about my excel proficiency. - I have 10+ years of experience More

$111 USD in 3 days
(0 Reviews)
0.0