Drop down

superfb

Board Regular
Joined
Oct 5, 2011
Messages
99
Hi I would like to have a drop down, 2 of them where the second one the options changed according to the option selected in the first drop down.

For e.g.
Dropdown 1. Drop down 2
Mike. If chosen Mike 24
Joseph. If chosen Joseph 15

Thanks
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

superfb

Board Regular
Joined
Oct 5, 2011
Messages
99
Hi I would like to have a drop down, 2 of them where the second one the options changed according to the option selected in the first drop down.

For e.g.
Dropdown 1. Drop down 2
Mike. If chosen Mike 24
Joseph. If chosen Joseph 15

Thanks

Also, if i change the dropdown 1 from Joseph can the 2nd dropdown go blank and let me select 15?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,312
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top