How to create travel template w/drop down menus
 

I want a template that allows me to create a travel itinerary template
whereby I can pull down a menu and "select" the traveler's name in one cell,
the airline in another cell...etc. etc.

How do I do this?

How to create travel template w/drop down menus
 

For help on creating DropDown menus from Data Validation see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlDataVal01.html

For more on DV also scroll through Debra's site at

http://www.contextures.on.ca/tiptech.html

Especially how to use a list from another worksheet by naming the listrange
on the other sheet.

Once you get it all set up as you like save the workbook as a true Template.

FileSave AsFile TypeMS Excel Template(*.xlt)


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 12:38:21 -0700, Veronica
wrote:

I want a template that allows me to create a travel itinerary template
whereby I can pull down a menu and "select" the traveler's name in one cell,
the airline in another cell...etc. etc.

How do I do this?