+ Reply to Thread
Results 1 to 9 of 9

Search engine

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    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.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,279

    Re: Search engine

    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

  3. #3
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Search engine

    Quote Originally Posted by davesexcel View Post
    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

  4. #4
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Search engine

    Quote Originally Posted by Ryan_Bernal View Post
    Here is the link.
    Thank you in advance.
    https://www.box.com/s/3ooj2ttxuqdkq95sf29q
    This is the excel file.
    Attached Files Attached Files

  5. #5
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Office 2013
    Posts
    887

    Re: Search engine

    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.
    Attached Files Attached Files
    Last edited by lilsnoop; 12-23-2012 at 06:46 PM. Reason: additional info

  6. #6
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Search engine

    Quote Originally Posted by lilsnoop View Post
    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!

  7. #7
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Office 2013
    Posts
    887

    Re: Search engine

    Glad I could help!

  8. #8
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Search engine

    Quote Originally Posted by lilsnoop View Post
    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:
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    12-19-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Search engine

    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).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1