Apply Auto Filter in selective worksheets and Copy to new workbook

Hi Folks,

How do I apply Autofilter to 3 odd numbered worksheets (for eg. Sheet1, Sheet3, Sheet5), copy the filtered data from 3 odd numbered worksheets and paste the data on Sheet1, Row 4, Column D of a new workbook which has column header that starts from Row 3 Column D. The filtered data needs to be pasted after the column header.

Thanks much!

Archer

Start by recording a macro.

You don't say what you want to filter by, how many colums in the data. Try attaching a dummy workbook

If you mean a recorded macro, then it will probably need editing.