I am using excel 2003. I have one excel file & in sheet1 i have lot of data. Data record as per below
column a1 : is header 1 to h1: is header 8
column a2 : application code
column b2 : partno
column c2 : description
column d2 : remark
column e2 : qty
What i require. Actually i required two category & two search terms.
For example: If In first search category if i have select "Header 1" & enter in search term : "02.2115" (applicationcode) & another search category if i have select "Header 3" & enter in search term : "piston" (description), this description anywhere in that particullary field for example first letter start from "piston", or "assly of piston". In that case search those word in anywhere it may be first or second or anyway but within those column only.
If application is 02.2115 & description is piston, then which partno is used?
In search (list box) result i want to display
...applicationcode : " "
...partno : " "
...description : " "
...remark : " "
...qty : " "
If you have any vba programm please confirm.
In view of the above please explain. Hope you will guide me. Thanks.
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com,http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too