Filtering Macro

[bruce88]

Do you guys know what macro i can use to filter data from a table and copy the filtered data to another worksheet?

 

[texasalynn]

here is an example

    Cells.AutoFilter
    Cells.AutoFilter Field:=3, Criteria1:="Dropout"
    Range("C3:C" & LR).SpecialCells(xlCellTypeVisible).Select
    Range("A3:D" & LR).Copy Destination:=Sheets(DSht).Cells(ALR, 1)
    Range("C3:C" & LR).EntireRow.Delete
    Cells.AutoFilter