Search engine

Can someone help me this?
i am want search engine that is built-in on excel.
i made this on user input box but i want it in excel worksheet and i don't know how to do that.
I am a beginner in excel.
Here is the captured image.
DATA.JPG
by the way i have "database" sheet which all the data has been stored.
i want to search item inside the database and place on the "view" worksheet.
just like on the attached picture.
Thank you in advance.

Originally Posted by davesexcel

It is hard to work with a picture.

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

Here is the link.
Thank you in advance.
https://www.box.com/s/3ooj2ttxuqdkq95sf29q

Originally Posted by Ryan_Bernal

Here is the link.
Thank you in advance.
https://www.box.com/s/3ooj2ttxuqdkq95sf29q

This is the excel file.

Originally Posted by lilsnoop

Hello..

I've attached some coding in your workbook that was developed on this forum awhile back; the author I cannot recall. Unfortunately it is a work around to what I believe you are attempting. I've created a different search button, which will populate a pop up search message box. You would then type in the series or child parts #, etc into it and it will populate the results where you wanted them. If this is something that helps maybe someone else can tweak it for you to get it exactly the way you want it. Best of luck!

edited to add: You might want to reconsider re-posting this thread in the programming section, which might aid you in getting more replies.

Thank you so much for the code. I will try to tweak it using some codes in the forum.
Merry Xmas!

Glad I could help!

Originally Posted by lilsnoop

Glad I could help!

I re-post this thread on programming section but unfortunately, rule 5 violation (duplicate post)
"Can someone tweak this workbook for me?
I am trying to make search engine.
Filter all the data on "Series" column that being inputted on the "Database" sheet and automatically lists down on Combo box drop down lists (Series Product).
When i type data on text boxes (component & child parts) and click the type of series, it will populate the results (row A 21) upon clicking the show data button. Reset button will reset all the data on text fields.

Somebody from this forum ( lilsnoop ) do the code but using input form pop-up box.
Thank you and merry xmas!"

here is the workbook:

Can be possible to add link on the search results? So that when i click the search result i can go to the actual location (cell).