Excel 2007 : Copy filtered data to a new sheet?

Hello everybody,

I hope you are all well. My question is quite simple. I have a file for my database with 10 sheets, who are similarly built (same columns). I would like to extract filtered data to another sheet who would be a recap.
I would like only to extract the columns A, B , and C (First name, name and another criteria) and the filter is applied on the column B.
I have Excel 2007. I hope that i have been clear, if you really need it i can upload an example (not very easy for me as data is confidential).

All the best,

Alain

Hi,
using Data - Filter - Advanced Filter you can paste filtered data where you like.Maybe doing the drill once while recording a macro will allow do repeat the process if needed.
Cheers