HOW DO I SHIFT ROWS BASED ON A GIVEN VALUE
 

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?

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.

MIKE K wrote:

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?

--

Dave Peterson