How do I extract data given a criteria from a data set into another tab?

[Robotrix]

I hope I can clearly explain my question here. I am seeking to extract only specific entries from a data collection of approximately 1500 rows given a specific criteria. I've provided a screen shot of what I"m looking at with some Mock data to help the process. To summarize: I want to be able to automatically pull all rows from "DATA SHEET 1" that begin with "CM-GF-20", and have them appear in "PAST LINE RUNS" sheet. The code "CM-GF-20" is dependent on cell H3 from "PAST LINE RUNS" sheet. I'm pretty sure it involves a sub-array formula of some sorts, but I don't seem to be able to get it to work, any and all help is appreciated!


-- removed inline image ---

 

[JoeMo]

Welcome to the board. Try using one of the tools available at the links below to post a sample of your data.

http://www.mrexcel.com/forum/2545970-post2.html

Download