+ Reply to Thread
Results 1 to 7 of 7

Creating a search function in excel 2007

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Creating a search function in excel 2007

    Hello all!

    I am training in medical transcription. I have started a list of medications I commonly come across while typing dictations, using Microsoft Excel 2007. This list is getting long, and it will keep getting longer. What I have done is created 4 columns: Brand Name, Generic Name, Therapeutic Category, and Description. The medications are sorted alphabetically, according to Brand name. Often, I find myself looking for the generic name of the drug, but sometimes I get the brand name. What I would like to do is incorporate a search bar at the top of the worksheet to allow me to search for the generic name (since that column is not sorted alphabetically). I know I could use the auto-sort function, but the search function would make things faster, and as I will get paid by piecework, I need to be speedy. Any suggestions on how I could program such a feature would be very much appreciated. Thanks!

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Creating a search function in excel 2007

    Hello lauraexcels,

    Welcome to the Forum.

    Please see if you could make use of the attached sample WorkBook.

    If you are satisfied with the solution, then you may also Click on the Star to the far left, at the bottom of this Post, to Add to my Reputation.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Creating a search function in excel 2007

    This seems like it will work nicely. I will need to customize it to work within my worksheet. Is that okay?


    EDIT: Thanks, glad to have found these forums!
    Last edited by lauraexcels; 08-26-2013 at 01:00 PM.

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Creating a search function in excel 2007

    Yes that is fine.

    Do with it what you like. As long as it solves your issue, I am happy.

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Creating a search function in excel 2007

    Hello lauraexcels,

    Thank you for adding to my Reputation.

    If you are satisfied with the solution I had given you, then please remember to mark your Thread as Solved.

  6. #6
    Registered User
    Join Date
    08-26-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Creating a search function in excel 2007

    Hi Winon,

    How do I mark it as solved?

    Thanks.

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Creating a search function in excel 2007

    Hi lauraexcels,

    At the top of your first Post or Thread, click on Thread Tools>Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search Box In Excel 2007
    By jordan682 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2013, 06:19 AM
  2. Need help creating search function of list
    By romeogbs19 in forum Excel General
    Replies: 15
    Last Post: 11-01-2012, 03:49 PM
  3. Need help creating custom VBA function in excel 2007
    By matt82mc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2011, 06:47 PM
  4. Creating Charts in excel 2007
    By sigenge2001 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-25-2009, 12:17 PM
  5. Creating an advanced search/find function
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-03-2008, 03:46 AM

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