Hello,


I have data tables in cells A1:D15, and have organised the auto filters in
the header cells A1 to D1
In cells X1 and Z1, I have the values =month(now()) and
month(date(year(now()),month(now())+1,1)) respectively

Is it possible to organise the auto filter from cell D1 to have the
following custom auto filter:

1) equal to = X1 ( i.e. whatever is located in cell
X1)

and

2) equal to =Z1


I tried this without success, and also tried to put the actual formulas in
the custom format boxes, but it didn't work either

It there a way to do this?

Thanks

André