Закрыт

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!

Квалификация: Ввод данных, Обработка данных, Excel, Visual Basic

Показать больше 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

О работодателе:
( 0 отзыв(-а, -ов) ) Chennai, India

ID проекта: #18722946

40 фрилансеров(-а) в среднем готовы выполнить эту работу за $120

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. Больше

$250 USD за 4 дней(-я)
(320 отзывов(-а))
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 Больше

$150 USD за 3 дней(-я)
(209 отзывов(-а))
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. Больше

$100 USD за 4 дней(-я)
(94 отзывов(-а))
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 Больше

$150 USD за 3 дней(-я)
(62 отзывов(-а))
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 за 3 дней(-я)
(27 отзывов(-а))
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 Больше

$150 USD за 3 дней(-я)
(6 отзывов(-а))
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 Больше

$100 USD за 1 день
(20 отзывов(-а))
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 Больше

$100 USD за 5 дней(-я)
(5 отзывов(-а))
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 за 7 дней(-я)
(7 отзывов(-а))
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 Больше

$30 USD за 3 дней(-я)
(4 отзывов(-а))
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 Больше

$155 USD за 3 дней(-я)
(1 отзыв)
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 Больше

$55 USD за 3 дней(-я)
(0 отзывов(-а))
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 за 5 дней(-я)
(0 отзывов(-а))
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 Больше

$150 USD за 3 дней(-я)
(0 отзывов(-а))
0.0
$222 USD за 3 дней(-я)
(0 отзывов(-а))
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 Больше

$222 USD за 3 дней(-я)
(0 отзывов(-а))
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 за 3 дней(-я)
(0 отзывов(-а))
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 Больше

$35 USD за 3 дней(-я)
(0 отзывов(-а))
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 за 2 дней(-я)
(0 отзывов(-а))
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 Больше

$111 USD за 3 дней(-я)
(0 отзывов(-а))
0.0