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
Try this
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
Meaning what exactly?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
Posting Permissions
Reply With Quote
