+ Reply to Thread
Results 1 to 7 of 7

Search result

  1. #1
    Registered User
    Join Date
    05-07-2008
    Posts
    22

    Thumbs up Search result

    Good Day;

    i have a database contain sheet from jan to dec, and i would like to display search result on different sheet call search.
    Search criteria :

    1. Complainant Name
    2. Number ***
    3. Email Address**
    4. Itracker No
    5. MyCERT No

    here i attach sample file
    Attached Files Attached Files

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

    Re: Search result

    What are you searching for?

  3. #3
    Registered User
    Join Date
    05-07-2008
    Posts
    22

    Re: Search result

    all the information as stated in search sheet

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

    Re: Search result

    What are you putting in the bluebox to search for?
    I will check back in another 8hrs

  5. #5
    Registered User
    Join Date
    05-07-2008
    Posts
    22

    Re: Search result

    when user key in below criteria they will get result (result info will be from sheet jan2010 to dec2010)

    1. Complainant Name
    2. Number ***
    3. Email Address**
    4. Itracker No
    5. MyCERT No

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

    Re: Search result

    Quote Originally Posted by rashim View Post
    when user key in below criteria they will get result (result info will be from sheet jan2010 to dec2010)

    1. Complainant Name
    2. Number ***
    3. Email Address**
    4. Itracker No
    5. MyCERT No
    So you are putting all of this information in the blue cell?

  7. #7
    Registered User
    Join Date
    05-07-2008
    Posts
    22

    Re: Search result

    yes, when user key in any value, the able to get result; eg. user get MyCERT No from complainer, when user key in the number in blue box, they will get all information for that complainer,and if posible when the user update any information on the search result it should auto update in database

+ 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