Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create 3 drop down menus in Excel, each relating to previous | Excel Worksheet Functions | |||
looking for template to track travel plans for 5 people | Excel Discussion (Misc queries) | |||
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL? | Excel Worksheet Functions | |||
How do you create dual drop down menus in excel 2000? | Excel Discussion (Misc queries) | |||
how do you create drop down menus for individual cells in excel? | Excel Worksheet Functions |