Macro/Formula to filter three columns at once

[erniepoe]

Hi all,

I'm trying to find a macro/formula that will let me filter three columns at once, on the criteria that any of the three cells in those three columns showing a date that is either the current month or anything in the past. The "current month" is determined by what is written in cell C2 on another worksheet (the "pipeline" worksheet).


Is this something that would be possible?

Thanks in advance for any help.

 

[cjcobra]

Create another column with the Month of each date, and autofilter on each of the items you want.