how to Export filtered Sharepoint List data into excel in 2007

I need to export only filtered data into excel from SharePoint List. When i filter and export it gives all data but I need only filtered data. Is it possible to export only filtered data in SharePoint 2007 List? And I need to filter on some columns like “Product Type”, Product Category”, “Name” and “Date Range”.

Any help would be appreciated.

Thanks Azad