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?

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?