Hello Paul, When I run the macro in the test sheet it works great, when I put it in mine and change some of the data (sheet names, destination cells) it will not work. But ok, what I see is that the result I am getting is the correct one. One question... in my original sheet there are no colors. Is it possible to get the same macro to run but "not on colors"?