View Single Post
  #1   Report Post  
 
Posts: n/a
Default Excel display on condition

I have one worksheet called Catalog, and one called Catalog Print.

Catalog is a list:

A B C
1 Quantity Part # Description

2 100 12345 Pen

3 24357 Eraser

4 50 67890 Pencil

5 34573 Whiteout


This goes on over 1000 rows. I go down the list and enter quantities
only for items i need to order.

Catalog Print is set up the same way. I want this to be a list of only
the items that I entered a quantity (the entire list is 50 pages). In
this case, it would look like this:

A B C
1 Quantity Part # Description

2 100 12345 Pen

3 50 67890 Pencil


How can I set up this Catalog Print worksheet?

Thanks,

Jayme