Thanks for your input guys but I've been thinking about this over night and i think i can explain it better.

On my sheet 'QCs' I have a list of 4 digit numbers (column A) i.e.

5542
4441
5412
5447
etc

On my sheet 'Raw Data' I have rows of data and somewhere in row E there should be a number that matches one from the list of numbers in 'QCs' i.e

A | B | C | D | E
TestDataNon | 12/04/08 | 13.21PM | Joe Bloggs | Set Up Int QC 5542
DataCleanUp | 19/02/08 | 12.21PM | Joe Bloggs | Set Up Int QC 4441


The output from this I need is to display, on a new sheet, groups OF all rows in 'Raw Data' which have the same QC number which will look something like

5542
DataCleanUp 19/02/08 12.21PM Joe Bloggs Set Up Int QC 5542
EditNewClass 11/02/07 19.43PM Joe Bloggs Max No Pa QC 5542
TestDataNon 12/04/08 13.21PM Joe Bloggs Set Up Int QC 5542

4441
DataCleanUp 19/02/08 12.21PM Joe Bloggs Set Up Int QC 4441
EditNewClass 11/02/07 19.43PM Joe Bloggs Max No Pa QC 4441
TestDataNon 12/04/08 13.21PM Joe Bloggs Set Up Int QC 4441

etc


I hope this explains it better. Again, any further help would be fantastic