Get data from another workbook

A

ashparr

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top