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
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