Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy specific records to new worksheet
i wish to copy data from all worksheets to one worksheet if they meet certain
criteria. basically i want data that is highlighted to be copied to the new worksheet.(i do not need the whole row data, just need data in col a to l to be copied). In addition to the data copied, i will need another column in the new worksheet for me to assign a value based on what colour it is highlight. any one can help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy specific records to new worksheet
http://www.rondebruin.nl/copy3.htm
-- Regards, Tom Ogilvy "violet" wrote: i wish to copy data from all worksheets to one worksheet if they meet certain criteria. basically i want data that is highlighted to be copied to the new worksheet.(i do not need the whole row data, just need data in col a to l to be copied). In addition to the data copied, i will need another column in the new worksheet for me to assign a value based on what colour it is highlight. any one can help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy specific data to second worksheet | New Users to Excel | |||
Copy specific records from a worksheet to another | Excel Worksheet Functions | |||
How do I copy records with specific text from one wkbk to another | Excel Worksheet Functions | |||
How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
MOVE/COPY GROUP OF RECORDS TO OTHER WORKSHEET | Excel Programming |