Completed

Automate VLOOKUP between two spreadsheets to create a third sheet of combined data

I have two spreadsheets that are output [url removed, login to view] each have a name that changes with each daily output.

One sheet includes a column of "file number" and a blank column of "ID", as well as other columns of data.

The second sheet includes the same "file number" data, and the "ID" column, with data entered, as well as other columns of data.

I want a program I can run that will apply VLOOKUP to populate the "ID" data from the second sheet into the first sheet's empty "ID" column, in the same row as the corresponding "file number", and save the updated sheet with a new name.

Skills: Excel, Visual Basic

See more: how to pull values from another worksheet excel, excel cross reference table, vlookup cross reference, how to get data from another sheet in excel using vlookup, how to cross reference two excel sheets, how to cross check two excel spreadsheets, how to cross reference names in excel, cross reference in excel 2016, create a web page using with a “nag” counter that reminds users to register for the e-commerce site they are visiting. , create graph csv data excel, create pdf mysql data, create real time data adapter wealth lab, create sheet zoho sheet api, create script harvest data, create sheet excel sheet

About the Employer:
( 1 review ) Atlanta, United States

Project ID: #16298691

Awarded to:

katiewells3

I am an Excel developer with 15 years professional experience building automated data processing and reporting solutions with VBA. There are quite a few approaches to handling the file name changes (e.g. have the fil More

$250 USD in 4 days
(18 Reviews)
4.5

56 freelancers are bidding on average $318 for this job

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) I am an Engineering Graduate with an MB More

$300 USD in 1 day
(555 Reviews)
8.2
cgullapalli

Hi, I am good at Excel and vba. Looking forward to discuss further in the chat. Please share me the file to work on. I can write script that transfer the data automatically. -Chandra

$250 USD in 0 days
(638 Reviews)
7.7
Webxpert4u

Hello, I am ready to create a macro/script to run auto a VLOOKUP to populate the ID data from the second sheet into the first sheet and will create a new file. Highly experienced in Excel Programming, Excel automati More

$250 USD in 1 day
(145 Reviews)
7.2
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.

$250 USD in 1 day
(233 Reviews)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$250 USD in 0 days
(183 Reviews)
6.7
cugamelover

I confirm that I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using cus More

$250 USD in 2 days
(175 Reviews)
7.0
maverick44000

Hello, I can write the required VLOOKUP script within a couple of hours. Please share the sheets so I may have a look and finish it off. I am ready to accept payment once you have tested the functionality. Thank More

$300 USD in 1 day
(85 Reviews)
6.9
TonmoyRoy111

Dear client I understand the scope of work. I have sound knowledge in excel and I have previously carried out a number of projects in excel using macros and formulas. Regarding this project I believe it can be done us More

$250 USD in 1 day
(242 Reviews)
6.4
mrbrave

Hi, Using Excel VBA, The macro can be developed which will automate the process for future. The macro can be completed very quickly(within 1 hour) and too at lower budget then you have initially set. I am availa More

$250 USD in 1 day
(212 Reviews)
6.6
paris2785

Hello! My name's Paris. I'm a reputable Excel VBA developer and would like to work with you on this project. I'm very comfortable with using macros to automate and speed up processes. I suggest creating a macro that w More

$250 USD in 3 days
(123 Reviews)
6.5
dgled

I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced form More

$500 USD in 3 days
(47 Reviews)
6.2
diorisaguilar

Very interesting project. It can be built using VBA macros and an option placed in the ribbon to trigger the action if you like, or it can be done as a standalone application

$260 USD in 1 day
(33 Reviews)
6.0
satishtl

- Using the filenumber can have the data populate into ID column from the second sheet. - Can be done using a click of a button. - Will be done in a day. - Have expertise in Excel automation, macros, formulas, c More

$250 USD in 0 days
(41 Reviews)
5.2
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll code your current Ms Exc More

$555 USD in 10 days
(29 Reviews)
5.7
RRconsultant

A proposal has not yet been provided

$388 USD in 2 days
(34 Reviews)
5.6
whitehorsetechn

Greeting, I have understood your Automate VLOOKUP between two spreadsheets to create a third sheet of combined data task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more More

$250 USD in 3 days
(11 Reviews)
4.8
rumarahman

I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Statistics Data Processing Data Collecting (Using Macro) MS More

$250 USD in 1 day
(27 Reviews)
4.9
aubrey03

I am an Excel macro expert. As you can see on my profile, all of my projects are in Excel. This is my specialization so I am the best person for this job.

$250 USD in 2 days
(21 Reviews)
4.9
JITINGOYAL1992

Greetings Hope you are doing well. I am a CPA Finalist and am engaged in providing a range of services majorly focusing on Bookkeeping, Cost Accounting, Financial Management and Advanced  Microsoft Excel. Looking at More

$250 USD in 3 days
(24 Reviews)
4.6
Developer000

I am here freelancer first to discuss the details of Automate VLOOKUP between two spreadsheets then i can sure about my price and the deadline. My way of working is not only to complete but also to provide enough More

$250 USD in 10 days
(11 Reviews)
4.4