Create separate list of only selected data

L

Lisa

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
 
G

Gord Dibben

Data>Filter>Autofilter QTY column for greater than 0

F5>Special>Visble cells>OK

Copy then paste to other sheet.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a 3D surface graph from 3 columns of data: one columnfor x, one for y, and one for z 3
WCG Stats Monday 28 January 2019 3
Data from 2 sheets to create a new sheet with user input? 1
WCG Stats Tuesday 22 August 2017 6
WCG Stats Saturday 12 August 2017 4
Summing data 6
Processing Text Data for importing into Excel 1
WCG Stats Sunday 10 September 2017 6

Top