+ Reply to Thread
Results 1 to 6 of 6

Searching Columns and Returning Row values

  1. #1
    Registered User
    Join Date
    05-27-2010
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2003
    Posts
    6

    Question Searching Columns and Returning Row values

    Hello everyone,

    I am sure this has been explained a million times on here so I do apologize. basically I am trying to write a macro or vba is neccessary that will search through entries of one column and return all the data in that row.

    Ex:

    Please Login or Register  to view this content.
    So basically I would want to create a search field that said "Please enter part number"....The user would enter P-04 and in a designated area " # & % * ( " would show up... Just an easy search and recall. Hope someone can help, thank you very much.
    Last edited by teylyn; 05-27-2010 at 08:13 PM.

  2. #2
    Registered User
    Join Date
    05-27-2010
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Searching Columns and Returning Row values

    As well a macro button would be desired to initiate the search, ideally

  3. #3
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Searching Columns and Returning Row values

    Hello jasteinh,

    is there a particular reason you want to do this with code? Since you enter the search term in a cell and want the search results to appear in cells as well, you may as well use a worksheet function, for exampl Vlookup.

    see attached.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-27-2010
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Searching Columns and Returning Row values

    Wow, that is perfect. Nice and easy, thank you very much teylyn!!!!

  5. #5
    Registered User
    Join Date
    05-27-2010
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Searching Columns and Returning Row values

    One other question. Say the info was on a different worksheet, is it possible to call and display data from other worksheets with VLOOKUP?

  6. #6
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Searching Columns and Returning Row values

    Yes. See attached. Lookup table on Sheet1, data entry and formulas on Sheet2.

    cheers
    Attached Files Attached Files

+ 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