I am trying to copy data in a column from one worksheet to another in the
same workbook, However I only want the data that meets a certain criteria. I
would like the data that I retrieve to be consolidated instead of showing
empty cells in bewtween. How do I do this?