Hey guys,
The macro below is supposed to compare two columns and, in case there is a difference in the two, copy the concerning row and paste it directly below marked in a different color.
The macro as it is is able to recognize the differences in the columns and the copying of the unequal row also works as it should, except for one thing: the row is being pasted at the very end of the columns and not directly below the one with the difference.
Example: if rows 15 and 43 are being compared and a difference is being found, the macro should copy row 15 and paste it directly below as row 16. Same for row 43, which should be copied and pasted as row 44.
Hope, I was able to demonstrate the issue I have with the macro. As I am fairly new to programming, especially with VBA, I am having some difficulties with it and have already spent many hours solving this problem.
I hope, someone is able to understand the issue and provide a solution or even an idea.
Thanks.
Bookmarks