Autofilter dates by setting a planning window

Hi Guys,

I'm using Excel 2007 and want to create a macro which will allow us to set a date autofilter based on the number of days we select

Cell E1 contaians a formula giving today's date
Cell G1 is used to select how many days forward we want to look
Column G, from G7 down is the date column we want to filter depending on the dyas selected in Cell G1

I've attached a sample file. Hope this helps, and many thanks in anticipation

Regards,

Cobwebs

No takers yet then???