Filtering Based on External Criteria
 

Hi,

I'm trying to filter a column named "Maturity Date" as follows:

The filter would be for items less than a date which would be in a cell in
another spreadsheet or at least in a cell outside of the filter range.

I would greatly appreciate any help with this.

Thanks in advance.

Filtering Based on External Criteria
 

Create a helper col to flag that criteria, then autofilter on that helper col

Eg if that criteria date is entered in say, Sheet2's A1
In the source Sheet1, where dates are running in A2 down
you could place in B2: =IF(A2="","",IF(A2<Sheet2!$A$1,"Y",""))
and copy B2 down to the last row of dates in col A.
Then autofilter on col B for "Y"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Youlan" wrote:
Hi,

I'm trying to filter a column named "Maturity Date" as follows:

The filter would be for items less than a date which would be in a cell in
another spreadsheet or at least in a cell outside of the filter range.

I would greatly appreciate any help with this.

Thanks in advance.