Reading Data from other work books using drop down menus?

**Couchy** · 03-13-2012, 11:30 AM

I want to calloborate "part" information from other workbooks into one sheet, so instead of pulling from one book for this, one book for that, it can be all put into one and pulled from there.

For example if i was to create a work sheet that included the following

PART NUMBER, MATERIAl, DESCRIPTION, CUSTOMER, PRICE, WEIGHT

how would i then use it in another workbook by selecting the part number from a drop down list, and then the required fields been filled in with the other information?

Thanks

**JBeaucaire** · 03-13-2012, 12:11 PM

The formula you will use is VLOOKUP. It works on closed workbooks, so after getting the formula in and working, you'll be able to close the "parts" workbook and it will keep working.

**BarryTSL** · 03-13-2012, 12:16 PM

I have attached a small sheet to show the look up formula you can use. But I dont think you can have a drop down box fed from a different sheet but easy enough to copy the part numbers over and set one up from there.

**darknation144** · 03-13-2012, 12:46 PM

Yeah your right you can't reference a closed workbook with a drop list. If you google "referencing closed workbooks" there is code to get around this.