Showing Macro Results in a new worksheet

Hello Everybody,
I'm new here and have not been lazy and I've tried with the help of the WWW to solve my problem, but I'm stuck now.

I'm using Microsoft Office Professional Plus 2013

I need to compare a large amount of data between 2 worksheets. I have solved it with the following macro (rows that have been deleted in the comparison sheet show in red in the original sheet, rows that have been added to the new sheet show in green and cells that have been amended in yellow. So far so good. As I have lots of data to compare, it takes too long to scroll through 11,000 rows to check which cells are highlighted. I would like to show the results in a 3rd worksheet with an extra column for the kind of change (delete, add, change) and then the whole row with the coloured changes.

How do I do this? Any advice appreciated.

Here is what I've done so far and it works like a treat

Please Login or Register  to view this content.

Thanks.

It's hard to reverse engineer what your file looks like from the code. Can you attach your actual file with sample data so we can see what results the macro produces? That will also help us to figure out what you want the new worksheet to look like.

The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Hi 6StringJazzer, thank you so much for looking into this. I've attached my file.

Urs

I've updated your code (the file you attached did not have any code) and added Sheet3 to put the results.

Glad to help. You are too kind!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.