Hi all,

I had an issue using a vlookup formula, and my other thread did not recieve any replies. I think its not possible. I basically wanted to define the file path for a vlookup using a concatenate based on the selection of a listbox populated with files from a specific directory. So I have turned to VBA to help resolve this.

So! I have X number of workbooks, with say 10 sheets, all with one table on each sheet. I have a master workbook, with the same 10 sheets and tables, which i want to populate, based on the workbook selection on the "Front Page". Imagine the X workbooks as various scenarios. These will be populated by the user, and then selected from another workbook to manipulate further. I will highlight what I am struggling with - first, the vlookup sub in VBA. I have used a number of online examples, but I really cannot get them to work! Secondly, is how can I get the chosen source workbook to become part of the vlookup range (Filepath) in a vlookup sub? Once I have done this, do I simply replicate it 10 times, once for each table I want to populate?

Any direction on this would be very gratefully received! Previous post is here

http://www.excelforum.com/excel-form...94#post2986994