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

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

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

Hi
Simply use Autofilter on the amount (choose nonblanks from the
dropdown)). Then copy and paste what you have over to the other
worksheet. Only the records with amounts will copy over.
regards
Paul

(tango) wrote in message . com...
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