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?
|