search engine in excel

**Mrrobinson** · 06-18-2008, 10:41 PM

valve type diameter price brand
1) pneumatic butterfly 500 3200 AA
2) hydraulic butterfly 600 3000 BB

Above is the example of the list of price comparison for valves where the information in every row will be random and will not be categorized accordingly.

How can i make a search engine where i key in the information for "valve', "type" and "diameter", it will list out all the prices and brands with the same information that i key in earlier.

for example- when i key in "pneumatic, butterfly and diameter", i will get the list of the prices and brands.

Thanks a lot

**Mrrobinson** · 06-18-2008, 10:45 PM

........valve.....type..diameter..price..brand
1) pneumatic butterfly 500 3200 AA
2) hydraulic butterfly 600 3000 BB

Above is the example of the list of price comparison for valves where the information in every row will be random and will not be categorized accordingly.

How can i make a search engine where i key in the information for "valve', "type" and "diameter", it will list out all the prices and brands with the same information that i key in earlier.

for example- when i key in "pneumatic, butterfly and diameter", i will get the list of the prices and brands.

Thanks a lot

**shg** · 06-18-2008, 10:47 PM

How about Autofilter?

**shg** · 06-18-2008, 10:51 PM

Threads merged. Please don't post the same question twice.

**Mrrobinson** · 06-18-2008, 11:58 PM

sorry i thought i haven't posted the thread.

by using the advance filter i manage to filter the range and copy to another location.

but how can i make the filtered range automatically filter when i alter the values in the criteria range instead of repeating the steps?

**rylo** · 06-19-2008, 12:40 AM

Hi

Will you always be using all 3 criteria to make your selections? Or could you be using 1 or any mix of the options?

rylo

**Mrrobinson** · 06-19-2008, 01:09 AM

i will be using 3 or more criteria to make my selection.

thanks for your reply

.

**Mrrobinson** · 06-19-2008, 01:37 AM

how do i make a search engine in excel?

for example i will have a list of this table:

actuator type diameter price brand
1) pneumatic butterfly 500 3200 AA
2) hydraulic butterfly 600 3000 BB

i want to make a search engine where i key in 3 criteria which are the "actuator", "type" and "diameter", excel will filter the table and list out all the prices and brands with the same criteria in other columns

thanks a lot for your reply

**BigBas** · 06-19-2008, 01:44 AM

Are you sure you need a "search engine"? The built in Excel Auto Filter Feature does basically what you need to do. Is there any reason it doesn't suit your needs?

**Mrrobinson** · 06-22-2008, 10:56 PM

i have created a sheet which will filter the database and paste the filtered data to another sheet and sort ascending the filtered data. this is the code :

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A4:F4")) Is Nothing Then
Dim DataSH As Worksheet
Set DataSH = Sheets("Database")
DataSH.Range("A:M").AdvancedFilter action:=xlFilterCopy, copytorange:=Range("A9:M9"), criteriarange:=Range("A3:F4")
Range("A10:J500").Sort Key1:=Range("J10"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod _
:=xlStroke, DataOption1:=xlSortNormal
End If
End Sub

but now i want to add a scroll down bar on the criteria range, something like the autofilter, just the filtered data will paste to another sheet n automatically sort ascending then.

can anyone help me with the code? thanks

**rylo** · 06-22-2008, 11:29 PM

Hi

Sorry not sure I follow. Do you want an incell dropdown, that shows a list of the unique items for a particular column, that can be applied to the criteria section?

rylo