I'ld like to automate a custom filter I use frequently
every day.

It first filters on a couple of criteria which are no
problem, but then I need to filter on whatever today's
date is (less than or equal to).

I've tried a couple of ways, including getting it to copy
from a cell containing =today() and pasting the value in,
but that doesn't work - it just leaves it blank, which is
worse than useless.

I suspect a bit of VBA will solve this, but I'm not too
hot on that. Anyone any bright ideas? TIA