how to copy records with amount only from 1 sheet to another

M

mango

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
 
Top