John,

I can't use a filter because it isn't automatic. The data I am dealing with
are in a spreadsheet that will be used over and over again. It can't contain
anything that requires action beyond input into a series of forms.

"John Bundy" wrote:

Without messing with programming you can use an AutoFilter. You can then
move these if you want.

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"cminor" wrote in message
...
I am trying to create a list of data based on nonblank or nonzero cells in
another list. More specific: I have a group of cells, 30 Rows by 8
Columns,
which contain data (numeric) that represent quantities of 30 items from 8
categories. Each category is then totalled in the 9th column. In columns
10
and 11, I have the item name and price. Elsewhere in the worksheet, I
need
to list all items that have a total quantity greater than zero along with
the
item name and price. I expect this to be 6 or 8 items out of the 30.

What I am trying to avoid is listing all 30 items and having some with
zero
quantities. Where the nonzero items will eventually be listed is a page
to
be printed and I don't need to waste paper.