Thank you, this is just what I was looking for!

"Debra Dalgleish" wrote:

There are instructions here for adding a customer address to an order
form, that you could adapt to your workbook:

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

dbrumit wrote:
Thanks for the quick response, I am very new to this, our list of addresses
would only be about 10 or so. I am having trouble getting the street, city
state and zip to line up. Example would be:

Column A Column B
Ship to: 123 company
45 test road
Anytown, DE 19713


Can this be done?

Thanks,

Dan
"Sean Timmons" wrote:


Hopefully, this list is not too large

in the desired cell, go to Data-Validation
select from: List
Highlight the list of ship to addresses.

"dbrumit" wrote:


I have a form used for shipping and would like to select ship to adresses
from a list or with a code maybe? i do not have acess. Could someone help me
set this up?

Thanks,
Dan



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html