Suoritettu

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.

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

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

Projektin tunnus: #16298691

Myönnetty käyttäjälle:

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

$250 USD 4 päivässä
(18 Arvostelua)
4.5

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

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

$300 USD 1 päivässä
(555 arvostelua)
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 0 päivässä
(638 arvostelua)
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 Lisää

$250 USD 1 päivässä
(145 arvostelua)
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 1 päivässä
(233 arvostelua)
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 0 päivässä
(183 arvostelua)
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 Lisää

$250 USD 2 päivässä
(175 arvostelua)
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 Lisää

$300 USD 1 päivässä
(85 arvostelua)
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 Lisää

$250 USD 1 päivässä
(242 arvostelua)
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 Lisää

$250 USD 1 päivässä
(212 arvostelua)
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 Lisää

$250 USD 3 päivässä
(123 arvostelua)
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 Lisää

$500 USD 3 päivässä
(47 arvostelua)
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 1 päivässä
(33 arvostelua)
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 Lisää

$250 USD 0 päivässä
(41 arvostelua)
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 Lisää

$555 USD 10 päivässä
(29 arvostelua)
5.7
RRconsultant

A proposal has not yet been provided

$388 USD 2 päivässä
(34 arvostelua)
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 Lisää

$250 USD 3 päivässä
(11 arvostelua)
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 Lisää

$250 USD 1 päivässä
(27 arvostelua)
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 2 päivässä
(21 arvostelua)
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 Lisää

$250 USD 3 päivässä
(24 arvostelua)
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 Lisää

$250 USD 10 päivässä
(11 arvostelua)
4.4