View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
juanpablo juanpablo is offline
external usenet poster
 
Posts: 108
Default Help with Program

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