Results 1 to 3 of 3

Formula to pull rows of data based on a column cell value (Criteria)

Threaded View

PaulLor89 Formula to pull rows of data... 04-29-2013, 04:26 PM
Pete_UK Re: Formula to pull rows of... 04-29-2013, 05:42 PM
PaulLor89 Re: Formula to pull rows of... 04-30-2013, 11:26 AM
  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    Wisconsin, WI
    MS-Off Ver
    Excel 2007
    Posts
    37

    Formula to pull rows of data based on a column cell value (Criteria)

    Curious if it's possible to create a formula which pulls rows of data into another worksheet in the same workbook (Have formulas already in place in the desire worksheets). My intent is to auto update the worksheet when I add more data into the data source and avoid using a macro. Would like to organize based on Column "I" or PONumber. Attached is my test data. First worksheet is my datasource and the second worksheet is what I want pulled based on one (PONumber) criteria in column "I".

    Any recommendation is welcome and if this is not possible or ideal please shut me down.
    Attached Files Attached Files

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