Selecting filtered data without column headings in macro

[scany42]

I am creating a macro from a large set of data. When I filter data from a particular column, I then take those results, select all the data (multiple columns and rows), and copy them over to another sheet. What do I need to tell macro so it selects all the filtered data but does not include column headings? It needs to be able to work no matter what amount of data results from the filter. Thanks.

 

[Momentman]

After filtering, you then need to check for the new lastrow in the data and copy from the second row to that lastrow. Am assuming in this case that my data is from A to E

lastrow = Range("A1").End(xlDown).Row
    Range("A2:E" & lastrow).Select
    Selection.Copy
'you can then paste in the new sheet