Use AdvancedFilter
http://www.ozgrid.com/Excel/advanced-filter.htm


--
Regards
Dave Hawley
www.ozgrid.com
"Kash" wrote in message
...
I was try to get the rows that matches below criteria, to sheet 'Search'

'Test' in column F of Sheet 'Data' and
'Final' in column J of Sheet 'Data' and
date less than 3 months which should be taken from column I Sheet 'Data'

Can anyone help me on this please..?