Importing Data from one workbook to another

I need to be able to select slave workbooks from inside a master workbook using a expandable explorer style file menu. then once the files are selected import data from specific cells in each.

the importing of the data should be no problem it just the user friendly method of selecting the files that is the issue!

Thanks

Hello lamgar,

Welcome to the Forum!

We will need a little more information about the worksheet layouts in order to help you. It would save time if you can post a copy of the master and one of the slave workbooks for review.

Sincerely,
Leith Ross

thanks got it done!