Hi Guys,

Do you know if exist a way to do a macro to select File A and File B and apply the vlookup based on a previous file selection ?


This is because I have Two Folder :

Folder A :

File 1
File 2
File 3

Folder B:


File 1
File 2
File 3

and I want to apply a vlookup between Folder A - File 1 and Folder B - File 1

Thanks for any advice