software

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?

Hi Petester,

1. quot;Autofilterquot; option in quot;DATA-gt;Filterquot; menu will filter data based on the
specified conditions (including non-zero),

2. Select the filtered data, goto the required sheet and right-click on the
required cell and use quot;Paste Specialquot; option and select values then press
quot;OKquot;.

With kind regards,
NAVEEN

quot;Petesterquot; wrote:

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