Re: programming for advanced filter using external criteria file
- From: "Jim Rech" <jrrech@xxxxxxxxxxx>
- Date: Wed, 21 Dec 2005 07:19:23 -0500
>>I don't know if excel allows this external criteria
Just curious, why not experiment yourself to find out? I wasn't sure so I
tried it. (Yeah, it does).
--
Jim
"xxx" <david4scb@xxxxxxxxxxx> wrote in message
news:eJcZVbcBGHA.4016@xxxxxxxxxxxxxxxxxxxxxxx
| 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 *** of 1.xls, then copy to the newly created *** 12 in 1.xls.
|
| I don't know if excel allows this external criteria, many thanks in
advance.
|
| my email: david4scb@xxxxxxxxxxx
|
|
.
- Follow-Ups:
- References:
- Prev by Date: Re: Changing a cell without selecting it
- Next by Date: clearing ranges
- Previous by thread: programming for advanced filter using external criteria file
- Next by thread: Re: programming for advanced filter using external criteria file
- Index(es):
