Create separate list of only selected data
 

I am needing to create a new sheet (Sheet 2) of information based on whether
an item is selected on another sheet (Sheet 1).

ie: (Sheet 1)
Item QTY Cost Total
Shoe 0 $33 $
Shirt 2 $70 $140
Pants 0 $104 $0
Jacket 1 $112 $120
Hutch 0 $173 $0



If I only want the 2 lines that are greater than 0 to be shown on my
summarized sheet, how do I show those 2 rows together instead of being
separated?

Sheet 2

Item Qty Cost Total
Shirt 2 $70 $140
Jacket 1 $112 $120

Create separate list of only selected data
 

DataFilterAutofilter QTY column for greater than 0

F5SpecialVisble cellsOK

Copy then paste to other sheet.


Gord Dibben MS Excel MVP

On Thu, 25 Sep 2008 11:52:09 -0700, Lisa
wrote:

I am needing to create a new sheet (Sheet 2) of information based on whether
an item is selected on another sheet (Sheet 1).

ie: (Sheet 1)
Item QTY Cost Total
Shoe 0 $33 $
Shirt 2 $70 $140
Pants 0 $104 $0
Jacket 1 $112 $120
Hutch 0 $173 $0



If I only want the 2 lines that are greater than 0 to be shown on my
summarized sheet, how do I show those 2 rows together instead of being
separated?

Sheet 2

Item Qty Cost Total
Shirt 2 $70 $140
Jacket 1 $112 $120