I have a business where items are consigned in retail stores. I have
200 different items in inventory and up to 10 quantity per item in
each store. But each retailer may only have 75 or so different
products. Monthly, I visit my accounts with a form listing all of the
products in my inventory. I write a number in a "quantity sold"
column. I then refill what was sold. I then give a copy of this form
to the retailer as a "service report". I use this form to keep track
of what and how many were sold. I enter this into an invoice program
on my home PC.

I recently purchased a Pocket PC(AXIM3i) which has pocket Excel installed. 
What I want to do is have an Excel worksheet on the Pocket PC that I
can enter quantity sold data into as I inventory the items. This I
know how to build. But, I also want a worksheet linked to this data
that only captures the items actually sold and quantity. This I would
print with a portable printer and give to the retailer before I leave.
I do not want a copy of the original sheet with the 200 items listed
and only entries sold for about 50 items. I want a sheet that captures
only the rows of information that has a number entered as the quantity
sold. This I do not know how to do. I have read all of the Excel
functions. Some look promising, but I am not good at combining
functions.

Example:

Quantity sold     Item Number     Description

1                 2001            widget
3                 2002            better widget
                  2003            great widget
1                 2004            super widget
                  2005            deluxe widget
2                 2006            ultimate widget


This is what I want captured on a separate worksheet:


quantity sold   item number   description
1                 2001            widget
3                 2002            better widget
1                 2004            super widget
2                 2006            ultimate widget

Notice no item 2003 or 2005

How do I accomplish this? Please give me an example of a formula to
place on worksheet 2 to capture only the items which have been sold
from worksheet 1.


Will tip for speed and efficiency of response.

---

Clarification of Question by nommel-ga on 15 Jan 2004 00:28 PST

One thing I forgot.
I would like the data on the 2nd worksheet in 2 rows. I mean, 6
columns. not just three columns 50 rows tall. More like:

Quantity Sold   Item #  Description   Quantity Sold   Item#   Description


6 columns 25 or so rows tall. This will make it look better when printed.
If not possible, or too difficult, One column centered would work. 
I am a big tipper!

Use Data > Filter > Autofilter.  From the dropdown on the quantity
sold column select "nonblanks"

Thanks Nelson,
I can't find the Data>filter>auto filter on the pocket Excel

Sorry 'bout that.  Must just be a feature of the full version.

Nommel, can you be more specific about the excel you got?
I mean u got complete excel installed ?? and which version is it ?

btw, I would suggest you to go thorugh PivotTable and PivotChart Report.
(Data > PivotTable and PivotChart Report)
tell me if you can find this in your EXCEL.

best of luck

if you use MSN instant messenger than you can add me at najam_us_saquib@hotmail.com
we might discuss this matter there when we both meet online or post a reply here

Thank you for the advice. I will try the pivot table idea. I have
Excel 2000 on my laptop and pocket Excel on my handheld. I would
prefer to be able to use only my handheld when I am "on the road".
Then sync with my laptop at home. I want to be able to print out a
report and invoice from the handheld. IF this is not possible, I guess
I could take my laptop "on the road" and sync there to run the
reports. I just have so much important stuff on the laptop that I
would rather keep it in a safe place at home, not in my car on the
road.
I am just hoping for a "formula" approach to this problem run from
worksheet 2 to capture only the items sold from worksheet 1. Skipping
the rows that have no information entered into the "quantity sold"
column. Maybe this is not possible, I do appreciate the suggestions I
am receiving.
Regards,
Rick

Hi again...
you didn't tell me if you got pivottable and pivotchart report in your
excel 2000 btw, I m sure that it's included in full excel
anyways, there are three ways of doing what you are looking for.
1)autofilter
2)pivottable
3)macro
best of luck.....

Thanks Nelson and Nsaquib I was able to find the auto filter on my
Pocker PC. It has a different path, but it is there. After a few
minutes of tinkering it worked perfectly. I appreciate the assistance.

Rick