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.
Bookmarks