Consolidating Lists on Information

[Guest]

I have a spreadsheet with a long list of data.

I would like to extract a subset of that data, based on criteria in other
columns. The results should go to another part of the spreadsheet, and need
to be "printable".

I can insert a macro that looks at the field and then copies the data, if
the criteria is met, but then I have a big gap in the results and the printed
report doesn't look good. I also have a problem if/when new entries are made
to the data.

I need a macro that can copy only the qualified data to the portion of the
sheet, with no gaps.

Data
xxxxxxxxxxxxxxxxxxxx aaa
xxxxxxxxxxxxxxxxxxxx aaa
xxxxxxxxxxxxxxxxxxxx aaa
xxxxxxxxxxxxxxxxxxxx bbb
xxxxxxxxxxxxxxxxxxxx aaa
xxxxxxxxxxxxxxxxxxxx cccc
xxxxxxxxxxxxxxxxxxxx bbb

Results should be

xxxxxxxxxxxxxxxxxxxx bbb
xxxxxxxxxxxxxxxxxxxx bbb

Am I explaining this right?

 

[Nigel]

If you apply an autofilter, then filter the rows required copy paste the
result to another sheet, that might do it? Most of the code to do this can
be recorded in a macro, then adjust the code to allow for the different
length of rows showing in the filtered sheet.