+ Reply to Thread
Results 1 to 1 of 1

Display Results in a new worksheet based on Criteria Data

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    1

    Display Results in a new worksheet based on Criteria Data

    I have a worksheet with information in several columns. I would like to display all that information on a new worksheet based on certain column data results

    Example

    NAME PREPARED RELEASED ACCEPTED EXTENSION
    Smith, Alan p/p 4/5/13 4/5/13
    Smith, Janet ext
    Smith, Robert p/p 3/15/13 3/16/13
    Smith, Alex p/p 3/20/13 3/20/13
    Smith, Fran
    Smith, Laurie
    Smith, Melissa p/p 4/1/13 4/1/13

    I would like to have another worksheet display the results if:
    If Column B = p/p
    and
    If Column E = ext

    I would like the new worksheet to update every time I open the file, so if data is entered on the original worksheet, it will update the RESULTS worksheet

    Is this possible? If so, what function would I use?
    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