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?

Your Caps key is locked in and it sounds like you're yelling. It is also
difficult to read.
One way is to sort all your data on Column C, descending. This will put all
the zeros at the bottom. You can then Cut and Paste to another sheet is you
wish. There are other ways also. HTH Otto
"MIKE K" <MIKE wrote in message
...
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 guess I wasn't specific enough. How do I sort this way using a function key
or macro so the typical layman doesn't have to remember how to do it?

"Otto Moehrbach" wrote:

Your Caps key is locked in and it sounds like you're yelling. It is also
difficult to read.
One way is to sort all your data on Column C, descending. This will put all
the zeros at the bottom. You can then Cut and Paste to another sheet is you
wish. There are other ways also. HTH Otto
"MIKE K" <MIKE wrote in message
...
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?