date filter using macros
 

Hi,

I am trying to create a macro to filter on date ranges in sheet 2 based
on inputs (date) from sheet1.

Eg: sheet 1:

B4 cell value: 1-Jul-06
B7 cell value: 31-Jul-06

assume date list is in sheet 2 range a1
I want the macro to pick up values of B4 and B7 from sheet 1 and filter
the list based on the criteria.

I am able to do a custom filter in sheet 2 but i need help with code to
pick up values from shet1 and then do the filter.

Can some one help me?

Thanks,
R