Hi,buddy,

very glad to meet you guys, I have a question regarding to advanced filter
in EXCEL.

I have 2 excel files: one is called 1.xls(date source)and the other called
2.xls(criteria).

now I want to use a region in one sheet (sheetname called 22) in 2.xls as
criteria, select macthing records in

11 sheet of 1.xls, then copy to the newly created sheet 12 in 1.xls.

I don't know if excel allows this external criteria, many thanks in advance.

my email: