Validation

[juanpablo]

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

 

[Dave]

Hi JP,
Check out this link at Debra Dalgleish's site.
http://www.contextures.com/xlDataVal13.html
Regards - Dave.

 

[juanpablo]

Ive seen that site, but it does not explain how to make excel show on some
cells the result of two parameters. (week and destination)

 

[juanpablo]

The following code, inserts the result of some data on a sheet, when a week
numer is selected.
How do I modify it, so whenever I select the week, it erases the previous
data, and only show the data for the selected week?


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 2 And Target.Column = 3 Then
'calculate criteria cell in case calculation mode is manual
Sheets("ProductsList").Range("Criteria").Calculate
Worksheets("ProductsList").Range("Database") _
.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("ProductsList").Range("Criteria"), _
CopyToRange:=Range("A6:G6"), Unique:=False
'calculate summary total in case calculation mode is manual
Sheets("Data Entry").Range("D2").Calculate
End If
End Sub