Hi,
Im trying to copy rows from a parts list to an invoice sheet only when there is a number in the quantity column, ie
part price quantity
nail £1 1
gun £23
glue £2 2
In the above example I would like only the rows with figures in the quantity column to be copied across to another sheet, result should be
part price quantity
nail £1 1
glue £2 2
Many Thanks
Im trying to copy rows from a parts list to an invoice sheet only when there is a number in the quantity column, ie
part price quantity
nail £1 1
gun £23
glue £2 2
In the above example I would like only the rows with figures in the quantity column to be copied across to another sheet, result should be
part price quantity
nail £1 1
glue £2 2
Many Thanks