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.

Habilidades: Excel, Visual Basic

Veja mais: 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

Acerca do Empregador:
( 1 comentário ) Atlanta, United States

ID do Projeto: #16298691

Concedido a:


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 Mais

$250 USD em 4 dias
(24 Comentários)

54 freelancers estão ofertando em média $316 para esse trabalho


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

$300 USD em 1 dia
(617 Comentários)

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 dias
(759 Comentários)

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 Mais

$250 USD em 1 dia
(179 Comentários)

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 em 1 dia
(275 Comentários)

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 Mais

$300 USD em 1 dia
(86 Comentários)

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 dias
(206 Comentários)

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 Mais

$250 USD em 1 dia
(235 Comentários)

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 Mais

$500 USD in 3 dias
(56 Comentários)

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 Mais

$250 USD in 3 dias
(152 Comentários)

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 Mais

$250 USD in 2 dias
(180 Comentários)

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 Mais

$250 USD em 1 dia
(255 Comentários)

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 em 1 dia
(38 Comentários)

- 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 Mais

$250 USD in 0 dias
(48 Comentários)

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 Mais

$555 USD in 10 dias
(31 Comentários)

A proposal has not yet been provided

$388 USD in 2 dias
(40 Comentários)

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, Mais

$250 USD em 1 dia
(21 Comentários)

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 Mais

$250 USD in 3 dias
(13 Comentários)

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 dias
(32 Comentários)

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 Mais

$250 USD in 5 dias
(54 Comentários)

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 Mais

$250 USD em 1 dia
(30 Comentários)