Module that filters a column on worksheet and brings data into another tab

[banpreet]

Hello,

I would like to create a module in excel that filters a tab in my document and brings certain data from that tab to another tab. The tab I would like to get data from is called "Current Data". The column I would like to filter in that tab is E. I have to filter this column 5 times. The filters are "Total Sales", "Total GM", "Man Power", "Materials", and "labor". After filtering, in the tab I want to bring values from column C,D and AG to the new sheet, called "Total Sales". Then when I filter column E again, I would want to bring those same columns to the new sheet called "Total GM" and so on. If somebody can help me out with this code, I would very much appreciate it!

[Marc L]

Hi,

this is the common case for using an easy Excel advanced filter !