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