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
Again, thanks for any help.
--
mbqc
------------------------------------------------------------------------
mbqc's Profile: http://www.excelforum.com/member.php...o&userid=34207
View this thread:
http://www.excelforum.com/showthread...hreadid=539688