Q: I have a workbook that has 2 sheets.
1st sheet has 4 colums, Customer,Serial,Address and Phone.

2nd sheet is a work order and I am trying to get the information from one sheet to populate into the other by using a dropdown.

So, when I choose a customer name, the address,serial and phone is filled out without having to always keep adding each cell one at a time.

I took a "snapshot" of a demo to help me with my question.

http://www.mbqc.com/excel

I have purchased excel bible, but...................... DEEP!

Please emal any help to me at [email protected]

Again, thanks for any help.