data validation list or combo box from forms toolbar.You arent 100 per cent
clear to me.Do you want to pick a customer from a list and have their address
come up automatically in another cell?
--
paul
remove nospam for email addy!



"J.Lee" wrote:

How do I setup a drop down box for using addresses. I am creating an Estimate
spreedsheet and would like to select a customer with address from a drop down
box. Thanking you in advance