Two search category & two search terms

[Closed]
Report
Posts
12
Registration date
Tuesday June 29, 2010
Status
Member
Last seen
July 23, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Posts
12
Registration date
Tuesday June 29, 2010
Status
Member
Last seen
July 23, 2010

Select category : Header 1 & enter search terms : if 02.2105
Select category : Header 3 & enter search terms : if PISTON
after selecting above parameter result will be show all three records (one by one using next button) Piston suitable for 02.2105 application.

In Header 3 search terms what ever i search. Above is a example.
Posts
12
Registration date
Tuesday June 29, 2010
Status
Member
Last seen
July 23, 2010

Hope u will understand what i want. Awaited. Thanks for u r co-opration.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I think I do. But the issue is that you cannot have one text box to do both search

How many rows of records are you talking about here on main sheet
Posts
12
Registration date
Tuesday June 29, 2010
Status
Member
Last seen
July 23, 2010

Yes that why i m asking. Two category combo box & two search listbox required. presently only one i have. but i require two combobox & listbox for type search name.

In main sheet number of row atleast 50,000 (fifty thousand)
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
50,000 ? I am inclined toward use of filters and may be paste to a new sheet.
Let me ask you what you are exactly trying to design. Lets say there is no form and user filters the data, how it is different from what you are trying to do. Since you have multiple search, only thing that i can think of that use of filter (there is other way too but just too slow) Could you try to explain what you are trying to build here ( in general term as if you tell me that Mike want FTS and BTS, it will not make much sense to me :) )