Hi all,

I have probably named this poorly, but I have an excel need I can't figure out (or explain too well!). I have a spreadsheet that contains a list of products in the rows (Cell D to be specific) Other information about each product exists in the columns on either side. From Column L onward I have columns with People's names as headers, and the quantity of each product they ordered. The spreadsheet is long, and lots of people have 0 for a lot of things.

I would like to create two things-

1 - a copy of the data for each member but with only the rows that have a number greater than 0 in.
2 - a copy of the data but restricted just by the products that have at least one person to select, and include the order quantities for each person who ordered it.

Thanks in advance- this forum is great!

Mel

Very basic idea of what I have:

Product Person name (qty) Person (price calculated''0 Person name (qty) Person (price calculated''0 Person name (qty) Person (price calculated''0
Product A 7 $7.00 0 $0.00 2 2
Product B 8 $8.00 0 $0.00 12 $12.00
Product C 15 $15.00 0 $0.00 0 2$0.00
Product D 1 $1.00 0 $0.00 2 2
Product E 7 $7.00 0 $0.00 5 $5.00
Product F 6 $6.00 11 $11.00 0 $0.00