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

T

tango

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
 
P

Paul Robinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to copy records with amount only from 1 sheet to another 1
macro to copy columns from one sheet to another sheet 4
Search for values in a sheet and copy found records one after theother in another sheet 12
Collect Info from Wkbks in a Folder with Criteria to 1 sheet. CHAL 20
macro to copy columns and paste into another sheet 0
copy specific cells from sheets if the information is correct 3
Copy work sheet to another work book, pros and cons 1
Macro Excel to automatise the copy of data from one worksheet to another sheet 1

Top