Get data from another workbook
 

Hi everyone,

I have a few questions that i hope you can help me with. I have two
files in the same directory. One is called "item list" & this stores
information on a load of items, The other is just called "test" for
now.

What i want to do is when the "test" file is opened it grabs a
selection of data from the other workbook and puts that on my sheet.

Also once the sheet is open i would like to have a drop down box that
displays different products & when one is selected then it shows the
data from the other workbook in the cells below

hope you get an idea of what im trying to do,

ash