Displaying itmes in list that have a quanity next to them

P

Paul D

I have a spread sheet with 2 tabs. I use the 1st tab to
list items and prices..
i.e. Quanity Description Price
1 Telephone A 34.95
0 telephone B 43.95
5 Telephone C 32.43
7 Telephone D 54.98
0 Telephone E 43.44

Note I have about 60 of these

On Sheet 2, I want to list in a Row by Row, the items that
have a quanity next to them
i.e. Quanity Description Price
1 Telephone A 34.95
5 Telephone C 32.43
7 Telephone D 54.98

How can I get this done
 
F

Frank Kabel

Hi
one way: use 'Data - Filter - Special Filter' and choose as target a
different range
 
J

jammy

one way is to use automatic filters to filter out what you don't wan
from the first tab, then copy and paste into the second tab.

highlight your heading row and go to data>filter>autofilter
then click the drop down box for the quantity and go to custom filter
use does not equal 0.

that gets rid of any that are 0 (can also be used to give you greate
than, inside a range or whatever).

then just copy and paste the
 
Top