Drop Down list that fills in other cells
 

I want to create a spreadsheet that has a drop down list that will let me select a customer and have the information pertaining to that customer filled in the spreadsheet at respective cells.
For example,
If I select customer A, then certain cells will fill in with a range of information that only pertains to that customer. While I can go on to Customer B and different information would fill into the same cells as the previous customer. Any/all ideas and help would be greatly appreciated.

Drop Down list that fills in other cells
 

What Debra Dalgleish describes in this web page is exactly what you're
looking for.

http://www.contextures.com/xlOrderForm01.html


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"frankjh19701" wrote in message
...

I want to create a spreadsheet that has a drop down list that will let
me select a customer and have the information pertaining to that
customer filled in the spreadsheet at respective cells.
For example,
If I select customer A, then certain cells will fill in with a range of
information that only pertains to that customer. While I can go on to
Customer B and different information would fill into the same cells as
the previous customer. Any/all ideas and help would be greatly
appreciated.




--
frankjh19701