Excel Combo Box using External Excel data...

E

Enigma007x

Heya -

I am sure this has been asked before in various ways, but I cannot fin
anything referring to my specific situation. I need to create a purchas
order spreadsheet. Multiple items will be listed on the sheet along wit
their manufacturer, price, etc.

To take an easy example of what I am looking to do, I will look at th
manufacturer field of each item. I want this field to be a combo bo
listing all of the companies I have in a separate xls file calle
Company.xls (and Company sheet).

I also need to make this so that if the user chooses to add another ro
(and drags the definitions down) the next item could also have an ite
box for manufacturer. The only way I have been able to do this so fa
has been through validation.

Could someone give me a push in the right direction as to what I woul
want to do? Thanks!

Enigm
 

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