VBA code needed to start vlookup to another workbook
Budget: $25 – $50 USD
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 9.7.2021.XLSX)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)
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 9.7.2021.XLSX)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)