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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Paul D" <(E-Mail Removed)> schrieb im Newsbeitrag
news:15fcd01c41bca$3f7c21e0$(E-Mail Removed)...
> 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

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

--
Message posted from http://www.ExcelForum.com