Excel display on condition

[jaymerozendaal]

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

 

[George Nicholson]

Not sure you need 2 sheets for what you are describing. If your data is in a
true List (no completely blank rows) the following should work:

-Select your Column header row
-Data>Filter>AutoFilter
-In the drop-down under Quantity, select "Non-Blanks" (or Custom: > 0)

The only visible rows should be the rows where you entered a Quantity, which
you can print.

If you want a copy of just the filtered data, you can copy the sheet in its
filtered state and paste it on another sheet. The result is only what was
visible when you copied.

HTH,

 

[jaymerozendaal]

I suppose that will work too. Thanks.