Hi.

I am using Excel 2007 in a vista premium home esition. I have 3 worksheets,
Sales Order, Companys, Product.
On the sales order, I have a box I want to call company ID #, I want to
select the company and I want it to populate the Companies address,  I have
the following Addess, City, County, State, Zip.

I would like a window to show me company ID and Name, and when I click on it
I want to put the ID number in the cell and like I mentioned the address
filled out.

Now I would like to know where I can find more info on this so I can read
about it and do it or else just some basic info so I can attempt to do it
myself.

Thanks,

Peter