How to create a dynamic filter using a macro

[CesarSanchez10]

Hi - 

So I'm having some difficulty creating a simple macro. All I need is to be able to filter some dates dynamically. There are 73 conditions within my data so I'm trying to avoid creating 73 filters. So I think a macro is the right approach..

I have company data with the column "Trade Date" and want to filter them based on the table below...

Min_Trade Date	Max_Trade Date	Expression
2012-12-31	2013-01-31	[Trade Date] >= '2012-12-31' and [Trade Date] <= '2013-01-31'
2013-01-30	2013-02-28	[Trade Date] >= '2013-01-30' and [Trade Date] <= '2013-02-28'
2013-02-27	2013-03-28	[Trade Date] >= '2013-02-27' and [Trade Date] <= '2013-03-28'
2013-03-27	2013-04-30	[Trade Date] >= '2013-03-27' and [Trade Date] <= '2013-04-30'

Currently I do it manually and I'm using the expression column to filter the data but ideally, I would like to use the Min_Trade Date and Max_Trade Date values to create a batch macro 

which does this for all 73 months dynamically.

Is there a smart way of doing this?

Thank you very much for the help!

[CesarSanchez10]

Wow....This worked like a charm!

Thank you and everyone else!