Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all,
I have the following problem. % Lan %Lan % Lan % Aqua % Aqua % Aqua W MIA LAX JFK MIA LAX JFK 1 45 85 90 89 12 45 2 90 45 100 85 10 10 3 78 52 54 96 78 10 4 65 78 74 41 50 25 5 12 21 63 74 52 46 6 74 10 12 23 90 74 So in other sheet, I want to have a menu with two options, Select W(week#) and destination(MIA-LAX-JFK). When you select week 1 for example, it should display all the information related to week 1 depending the destination, if MIA is selected, then show %LAN MIA and %Aqua MIA. How can this be done??? JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |