+ Reply to Thread
Results 1 to 2 of 2

Search from provided data list and return all instances of given criteria

  1. #1
    Forum Contributor
    Join Date
    04-17-2012
    Location
    england
    MS-Off Ver
    Excel 2010
    Posts
    122

    Exclamation Search from provided data list and return all instances of given criteria

    Good Evening

    I am pretty new to the world of macros but love what they can achieve.

    I have looked online and tried to adapt codes that I have found but they are not able to achieve all that i want.


    I have attached a copy of my spread sheet

    My desired code would be to be able to select an individual from my data list i have and then search In the whole of the 'Late Log in' tab for the word late and when it matches the selected name and the word late it will return result, if there are lots of results then I would like every time they actually loggged in late in Cell D1 down and then in cell E1 down the date that the late log in occured.

    If this is achievable please can some one help.

    If there is any more info needed or I havent explained myself clearly just ask.

    Dave
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Search from provided data list and return all instances of given criteria

    Hi Dave1983,

    Try this:

    Please Login or Register  to view this content.
    I tested it with this:

    Please Login or Register  to view this content.
    and with this:

    Please Login or Register  to view this content.
    Last edited by xladept; 12-13-2012 at 06:14 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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