Hello All,
Sorry for my bad english, i'm french.
I have found on Debra's Website a nice tutorial which contains a macro to
automate a filter which is in another sheet.
It's working perfectly, the problem I have is that instead of using the
combo box in the same sheet I would like to use the combo box which is
located in another sheet but in the same workbook.
I'm not good at VBA scripting, here is the code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row = 3 And Target.Column = 3 Then
'calculate criteria cell in case calculation mode is manual

Worksheets("euList2").Range("h2").Calculate
Worksheets("euList2").Range("eutable2") _
.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("euList2").Range("h1:h2"), _
CopyToRange:=Range("A6:F6"), Unique:=False
End If
End Sub

how can I change the link to the combo box i'm using if the combo box is in
Cell H10 in my sheet name "Summary"??

Thanks a lot