How do I consolidate some cells in a column in Excel?

P

Petester

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?
 
N

NAVEEN

Hi Petester,

1. "Autofilter" option in "DATA->Filter" 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 "Paste Special" option and select values then press
"OK".

With kind regards,
NAVEEN
 
Top