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

I have two spreadsheets that are output [login to view URL] 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.

Taidot: Excel, Visual Basic

Näytä lisää: 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, php create table csv data, import excel sheet sql data base, create database normalize data, create graphs mysql data, automate iis site create, create hyperlink mysql data, aspnet create form post data, zoho api create sheet, create sheet excel sheet, create script harvest data, create sheet zoho sheet api, create real time data adapter wealth lab

Tietoa työnantajasta:
( 1 arvostelu ) Atlanta, United States

Projektin tunnus: #16298691

Myönnetty käyttäjälle:


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 Lisää

$250 USD 4 päivässä
(24 Arvostelua)

54 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Expert Excel Programmer on and have been featured by the freelancer community I am an Engineering Graduate with an MB Lisää

$300 USD 1 päivässä
(617 arvostelua)

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 0 päivässä
(759 arvostelua)

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 Lisää

$250 USD 1 päivässä
(179 arvostelua)

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 1 päivässä
(275 arvostelua)

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 Lisää

$300 USD 1 päivässä
(86 arvostelua)

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 0 päivässä
(206 arvostelua)

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 Lisää

$250 USD 1 päivässä
(235 arvostelua)

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 Lisää

$500 USD 3 päivässä
(56 arvostelua)

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 Lisää

$250 USD 3 päivässä
(152 arvostelua)

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 Lisää

$250 USD 2 päivässä
(180 arvostelua)

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 Lisää

$250 USD 1 päivässä
(255 arvostelua)

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 1 päivässä
(38 arvostelua)

- 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 Lisää

$250 USD 0 päivässä
(48 arvostelua)

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 Lisää

$555 USD 10 päivässä
(31 arvostelua)

A proposal has not yet been provided

$388 USD 2 päivässä
(40 arvostelua)

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Lisää

$250 USD 1 päivässä
(21 arvostelua)

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 Lisää

$250 USD 3 päivässä
(13 arvostelua)

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 2 päivässä
(32 arvostelua)

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can dev Lisää

$250 USD 5 päivässä
(54 arvostelua)

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 Lisää

$250 USD 1 päivässä
(30 arvostelua)