I have a table_array set up with 4 columns... pay item, unit, unit price and
qty. There are maybe 30 rows in the array and I want to search the qty
column for values greater than zero and then apply the contents of the
columns in the pay item, unit and unit price (in another worksheet) from the
same row where the qty was greater than zero.

If Excel does not find a value greater than zero then it must skip to the
next line in the taable array reporting only the content from col's 1, 2 and
3 in cells in another worksheet until it has looked at the last or 30th row.

Final is a list of pay items with qty, unit, unit price after only inputting
the qty values in the table_array.

I know this sounds confusing but can anyone help?