Solved: Filter & Transfer

[rangudu_2008]

I've developed some code to filter contents & transfer those filtered records to a new sheet.

How can this filtering be done automatically just by choosing a column to filter and then clicking a button? Can anybody help me out?

Ranga

[Bob Phillips]

You could trap the double-click event for the first row



Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Row = 1 Then

Cancel = True
'your code
End If
End Sub

[rangudu_2008]

How does this code work? Can anybody explain?