Results 1 to 9 of 9

Finding and Displaying data results from search criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    5

    Unhappy Finding and Displaying data results from search criteria

    Hi, I'm new and i am trying to create an easy to use search by macro VBA in excel.

    I have a sheet of information where i need to find the data records from either one of the 2 search criterias: Name and NRIC.

    Once a user enter either of this 2 search criterias, i need a macro to search through the data on Sheet "List" and
    return the results on the Sheet "Search".

    Within the list, a search criteria may appear more than once, the search results should display all of the records row by row on Sheet "Search".

    Would it be better to create a user form?

    Can someone kind please help me out on this?
    Attached Files Attached Files
    Last edited by winlam; 07-22-2012 at 11:20 PM. Reason: Add attachment

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