How to create a drop down list with different values

E

excelnovice

I'm a beginner of Excel 2000 and I would like to create a drop down list on
the airfares, where different locations can be chosen, and when a location is
chosen, the cost will appear in the colums on the right.

Expenses Unit Cost 1 Day 2Days
1. Airfares (here is where I need help)
2. Hotel $100 $100 $200
3.Transport $100 $100 $110
Total xxx xxx xxx

eg. If HK-GZ is chosen, I can see the cost appears in the same row. The end
result will be getting the total sum of all the expenses.

Would it be possible to make different choices by just using one worksheet?
How can I revert to "Airfares" and make a new choice again?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
How to make repeating drop-down lists? 2
How to create a bubble chart with more than 2 variables. 0
dependent, multiple variable, drop down list 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Link a text box based on drop down box with four options MS Word 365 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
No option to create a list in SharePoint Site 0

Top