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

I hope I was able to assist.

"mbqc" wrote:


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

Assist?

You help build me a Jet using parts from a Fort Pinto

Outstanding!!!

:)


--
mbqc
------------------------------------------------------------------------
mbqc's Profile: http://www.excelforum.com/member.php...o&userid=34207
View this thread: http://www.excelforum.com/showthread...hreadid=539688