HOW DO I SHIFT ROWS BASED ON A GIVEN VALUE

M

MIKE K

I HAVE A 38 PAGE PRICE LIST WHERE COLUMN "A" IS A DESCRIPTION OF THE ITEM,
COLUMN "B" IS THE PRICE, COLUMN "C" IS THE QUANTITY AND COLUMN "D" IS THE
TOTAL (B*C). HOW DO I SHIFT ALL ROWS TO THE TOP OF THE WORKSHEET WHERE COLUMN
"C" IS >0 AND LEAVE THE OTHER ROWS ALONE? OR MOVE ALL ROWS WITH A COLUMN C
VALUE >0 TO ANOTHER PAGE?
 
D

Dave Peterson

I'd apply data|filter|autofilter and show those rows with a value > 0.

Then I could copy and paste to another sheet.

Then come back and delete those rows.

===
I'm not quite sure what leave those other rows alone, but maybe selecting your
range and sorting by column C would be sufficient.
 
Top