| 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 | |||
Linear Mode
