Moving data from one sheet to another- How to?

[mbqc]

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.

[JLatham]

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 [email protected]
>
> 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
>
>

[mbqc]

Assist?

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

Outstanding!!!