Compare Multiple Columns in Multiple Sheets and Merge differences

[Robinsper]

Sorry for showing up so late, but like I said in my last post I went to bed after 5am and I'm dealing with a death in the family. I just want to say thank you soooo much for being on top of this, especially to p45cal who stuck around even after he provided the answer to my original question. Not to turn this into a match or anything, but I checked the code from snb and p45cal just in case anyone else reads this thread and is trying to figure out what worked for my particular situation; snb's suggestion took about 1 minute 40 secs to execute and some of the cells were mixed up between columns, I'm pretty sure that it's probably something to do with my particular circunstance and not the structure of the code, so thank you for the help snb. That being said, p45cal latest suggestion was perfect, taking only around 3 seconds to execute and keeping the structure of the cells intact while updating the data in them, a big thank you p45cal I owe you big time, this solution will allow me to stop worrying about this problem and start thinking about the next one . By the way, I don't need to copy the color from the Alpha sheet, however, I do need to color red the text that is copied over so I can tell what's changing over time since I have too many records to keep track of, so I just changed the interior color from vbYellow to vbRed. It all works the way I needed it to. Thanks again for the support and p45cal I hope I can pay it forward in the future.

p45cal .PNGsnb.PNG