Hi,

Please see data validation Lists

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

"SrA Flyboy21" wrote in message
...
I am trying to set up an invoice so that when I use a drop down list for
the
customer name, it will automatically enter the address in the column
oposite
the customer name. any help would be great!