+ Reply to Thread
Results 1 to 3 of 3

Extract Data Based on Multiple Criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    03-14-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    2

    Extract Data Based on Multiple Criteria

    I am trying to extract data from a spreadsheet on my company intranet based on 2 criteria and display it in my own spreadsheet.

    For example in the attached workbook if I wanted to lookup Ian Barry and only display his data.

    The company spreadsheet has quite a bit more data in it.

    Any help appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Extract Data Based on Multiple Criteria

    trevaaaaaaa,

    Welcome to the forum!
    Why not just use an autofilter to filter for the desired data? See attached
    Attached Files Attached Files
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    03-14-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Extract Data Based on Multiple Criteria

    Thanks tigeravatar,

    The source spreadsheet is a bit long winded to access on company's intranet.

    Was trying to find a clever way to automate the process.

+ 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