Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Add amount if record contains a value | Excel Worksheet Functions | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
How to record a sheet change showing row column sheet name and date? | Excel Programming |