Færdiggjort

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.

Evner: Excel, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) Atlanta, United States

Projekt ID: #16298691

Tildelt til:

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 Flere

$250 USD in 4 dage
(18 bedømmelser)
4.5

56 freelancere byder i gennemsnit $318 på dette 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 Flere

$300 USD på 1 dag
(555 bedømmelser)
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 dage
(638 bedømmelser)
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 Flere

$250 USD på 1 dag
(145 bedømmelser)
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 på 1 dag
(233 bedømmelser)
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 dage
(183 bedømmelser)
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 Flere

$250 USD in 2 dage
(175 bedømmelser)
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 Flere

$300 USD på 1 dag
(85 bedømmelser)
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 Flere

$250 USD på 1 dag
(242 bedømmelser)
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 Flere

$250 USD på 1 dag
(212 bedømmelser)
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 Flere

$250 USD in 3 dage
(123 bedømmelser)
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 Flere

$500 USD in 3 dage
(47 bedømmelser)
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 på 1 dag
(33 bedømmelser)
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 Flere

$250 USD in 0 dage
(41 bedømmelser)
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 Flere

$555 USD in 10 dage
(29 bedømmelser)
5.7
RRconsultant

A proposal has not yet been provided

$388 USD in 2 dage
(34 bedømmelser)
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 Flere

$250 USD in 3 dage
(11 bedømmelser)
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 Flere

$250 USD på 1 dag
(27 bedømmelser)
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 dage
(21 bedømmelser)
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 Flere

$250 USD in 3 dage
(24 bedømmelser)
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 Flere

$250 USD in 10 dage
(11 bedømmelser)
4.4