VBA code needed to start vlookup to another workbook

Completed Posted 2 years ago Paid on delivery

$25-50 USD

Paid on delivery

Completed Paid on delivery

I have a workbook that I need to create a code for that starts a vlookup into another workbook. I will try to simplify this as much as possible.

Current workbook is called "Automation File"

In this file I have tabs named AAA, BBB, CCC, DDD, and "Automation Page" that has some data in it as well.

Each tab like AAA, BBB, CCC, DDD all need vlookups done in column N and O from Row 2 all the way down to the last valued cell in Column M (its a different row in each tab, every time)

File path for the Vlookup is :I/this/is/a/test

There are daily files in this folder location. and each day that this macro is ran it will need to do a vlookup to a different folder. I would like it so I don't need to change the code to pull from a different file. the file names that the vlookup works through is "File name 9.7.2021".

Finally...from the file that opens, there are tabs with the same names as the main automation file i already have open. Tab "AAA" in the automation file would need to do a vlookup to tab "AAA" of the "File name 9.7.2021"

The Vlookup formula would be "=VLOOKUP(N2,(FILENAME [login to view URL])AAA'!$A:$C,3,0)

And then that formula would get dragged down until its in the same row as the last valued cell in column M. And then for this to loop for all of the other tabs (BBB, CCC, DDD)

Excel Visual Basic Visual Basic for Apps Data Processing VB.NET

Project ID: #31488341

About the project

15 proposals Remote project Active 2 years ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Awarded to:

MimiFL's Profile Picture
MimiFL

Hi, i believe i can code this for you immediately. If you are interested, please attach sample file (both master file and the current input file) so i can see exactly what needs to be done. I also have few follow up qu More

$30 USD in 1 day
(651 Reviews)
7.3

15 freelancers are bidding on average $47 for this job

Rasel2543's Profile Picture
Rasel2543

Hello there, I am expert in Excel. I have done many task like this. I have vast experience in VBA, Macro, Vlookup, Hlookup, Pivot tables, Pie chart, Graph. If you want to get your project done perfectly with 100% acc More

$50 USD in 1 day
(18 Reviews)
4.4
torrikress2's Profile Picture
torrikress2

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have a tons of experience in Excel, Excel VBA, Visual Basic, Data Processi More

$25 USD in 1 day
(1 Review)
1.0
jamesdobbs11's Profile Picture
jamesdobbs11

Hi Dear! I already check your description with carefully and very interesting your project. Also I have a development experience of project like your project. Specially I have more than 10 years of experience in softwa More

$30 USD in 1 day
(1 Review)
0.0
drmohsan's Profile Picture
drmohsan

Hi I have seen your requirements for the projects and willing to perform task as well. Let's have a chat for detailed discussion.

$35 USD in 7 days
(0 Reviews)
0.0
wliewsung's Profile Picture
wliewsung

Hello I have seen that you are looking for excel VBA developer I have already made many VBA program so I can do this job If you give me chance I will do my best for you Please send me message and let's start work I wil More

$80 USD in 1 day
(0 Reviews)
0.0
Pappuverma7043's Profile Picture
Pappuverma7043

I am data entry xpart my target is my work and any misteks work clinte low price work and taim clinte work that forwed Ms xcel xcel

$38 USD in 7 days
(0 Reviews)
0.0
Post a project like this