PUll from a list records with common data

[brunwynne]

I have a workbook with several rows corresponding to many distinct quality control samples 1 - 50. Each sample is identified by a number such as QC 1, QC 2, etc. The QC is run multiple times over a long time, so that after say a month of experiments I might have a collection of results for my 50 QC some run more often then others by chance. For each QC I quantitate multiple properties, so that I have numbers for molecule A, B, C, D etc for each run of any given QC.

QC 1 1 3 5 10 2 8
QC 50 2 6 4 9 2 11
QC 3 1.5 18 2 89 1 3 6
QC 1 1 5 6 0
What I want to do is pull every record that corresponds to when QC 1 was run. And be able to do this for QC 2, etc, so I can see how the QC material performs over time for the mutliple performance metrics we measure each time it is run. I don't even have to see the QC 1 note, I just need to know the pulled record corresponds to a QC 1 run experiment

QC 1 1 3 5 10 2 8
QC 1 1 5 6 0

Please can you suggest how I might code this? Each QC data set can be sorted into it's own workbook that is OK.

thanks!