Hi,

I have a problem , if anyone could help.
A worksheet has three columns down to row 14

A-B-C

Row A & B already have values like

COLA COLB COLC
1.Brushes 3 0
2.Gizmos 1 2
3.Bottles 0 1
4.Glasses 0 0

I need a formula which will scan down Column C, C1:C14 and if a cell
has a value greater than zero

Then move rowA2 rowB2 & RowC2 and RowA3 RowB3 & Rowc3 and place them
in row order on another worksheet.

Worksheet2

A B C
Gizmos 1 2
Bottles 0 1

I hope this makes sense, I've tried to explain it the best I could.

Thanks Stephen