+ Reply to Thread
Results 1 to 2 of 2

Simple search function and results display.

  1. #1
    Registered User
    Join Date
    01-17-2013
    Location
    in a land downunder
    MS-Off Ver
    Excel 2007
    Posts
    1

    Simple search function and results display.

    I am completely dumb about any type of coding. I know where the code goes and that's about it.

    My situation: I am creating an excel sheet of employees. It contains a photo, name, title, location, user id, email, and a column for "how I can help". The purpose of this doc is to help employees find experts in certain areas when people need help doing something. For example, a new project manager who is not familiar with the proper way to calculate costs accurately on a change request. I would like that person to be able to go to this sheet, enter some type of search criteria, i.e. PCR costs, finance, budget, etc., to find someone who may have listed one of those particular terms in the "How I can help" column. I would like the entire row of search results to be copied to another sheet to be displayed. They will also be able to search the entire sheet for a particular name or phone number, etc. not case sensitive would be amazing. If it only searches the "how I can help column" I am fine with that as well.

    Can anyone help me please???

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Simple search function and results display.

    We only help on certain problems not to create a worksheet for you.
    You must start first then if you encounter a problem on the worksheet it's the the time to ask a question to fellow members.
    Thanks.

    Attach a sample workbook.

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

    View Pic
    Last edited by arlu1201; 01-25-2013 at 02:30 AM. Reason: Thread title is fine.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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