create drop down for address list

[Marlis]

I want to create an invoice with a drop down list for the "Bill To" section.
Any help would be apreciated

 

[Anne Troy]

Much help, Marlis. Try this:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
And in particular, there's a link (on that same page) to a complete
invoicing system you might like even better.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Dave Peterson]

Maybe data|validation would work for you.

If you want to try this, take a look at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

 

[Debra Dalgleish]

And there are instructions for an order form here:

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

The "Ship to" instructions are at the end.