Hi Harry,
Thanks for your reply. My Active sheet where my data resides (I call it 'Main' sheet) has row 1 as Fields and other rows contain data. 9th and 10th columns are date columns where I filter dates as required. You suggested to put date in cell R1. but R1 is one of the Fields heading. So, how it will work? Thanks again.

Regards,
Tahir