PC Review


Reply
Thread Tools Rate Thread

Displaying itmes in list that have a quanity next to them

 
 
Paul D
Guest
Posts: n/a
 
      6th Apr 2004
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
 
Reply With Quote
 
 
 
 
Frank Kabel
Guest
Posts: n/a
 
      6th Apr 2004
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


 
Reply With Quote
 
jammy
Guest
Posts: n/a
 
      6th Apr 2004
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a quanity of items printed DevilDog1978 Microsoft Excel Misc 4 30th Mar 2010 04:43 PM
linking the selection of a drop-down list to a quanity in another =?Utf-8?B?TEo=?= Microsoft Excel Programming 2 8th Oct 2007 03:34 PM
MAP DRIVE QUANITY OF VISTA =?Utf-8?B?c3RldmU=?= Windows Vista Networking 1 8th Feb 2007 02:30 AM
Minimum quanity Query question James Mckillop Microsoft Access Queries 1 24th Aug 2004 06:07 PM
combo box not displaying data if limit to list opetion set and displaying item not in list.... Chris Strug Microsoft Access Form Coding 4 3rd Oct 2003 03:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:27 AM.