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?