dear all,

i maintain on 1 sheet all the staff's claims. every month i will copy
those records with claims to another sheet. may i know how to put in
script so that can scan through the whole sheet (as the no of staff
will increase over the years) and only copy over those record with
amount value?

name amount
andy 50.00
lucy 345.00
jack
jasmine 40.00
marry

i will only copy over andy, lucy and jasmine from this sheet over to
another sheet.

pls help. thanks