copy filtered data from multiple sheets

[tizwaz]

I want to extract data based on a criteria from several worksheets and copy to a blank worksheet. I have excel 2007 - I can do it using advanced filter for one sheet but not for multiple ones - can anyone help?

 

[SkipVought]

Hi,

I would use MS Query. In 2007, (I have 2003) i thnk that it's on the DATA tab, Other Data Sources, and select Excel as the source, and you workbook as the source file.

Each sheet will be listed like
[tt]
Sheet1$
Sheet2$
[/tt]
name followed by DOLLAR character.

Each sheet is like a table. Works best if row 1 is your table headings.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}