X
xxx
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: (e-mail address removed)
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: (e-mail address removed)