View Single Post
  #1   Report Post  
MIKE K
 
Posts: n/a
Default 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?