macro to copy data based on criteria

[arnab0711]

Hi,
I have this excel sheet,where I have an "Input" page where I have two criterias
Project Desc& Item Description which I will input
Now at the click of "SHOW DATA" Button,it will filter data based on those criterias in the "raw data" sheet,and copy them to another sheet

[Bob Phillips]

Try this

[arnab0711]

Its only working if I give the criterias exactly match,but I forgot to mention that,I would to see data if part criteria is also given.

[Bob Phillips]

Meaning what exactly?

[arnab0711]

It means if I input part of criteria in the "Input" sheet for criterias "Project desc" and "item Description" it will give show all row data that matches or close to match that criteria.
For example if I give my search criteria as "BYCS" for Project Desc and Vehicle as criteria for Item description it will show all rows that contains these two search terms in its criteria section of Project Desc and Item description.