Copy Row of Highlighted Cell

I've been comparing 2 sheets and then highlight differences, what I want to do is, how do I copy the entire row that there is a highlighted cell to another sheet?
Can you help me work this out?
Thank you

Here's my code on comparing

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Working on it. just wondering how to paste that copy code

Originally Posted by sintek

I would think adding some code after your highlight code...i.e.

Please Login or Register  to view this content.

It says invalid qualifier even though I changed it to shtSheet2 which is my Sheet2.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

Thank you for the suggestion, but for some reason it doesn't work.

Originally Posted by sintek

Please upload a sample workbook so that we can see your exact scenario....

Here's my sample.
https://drive.google.com/open?id=0B4...0VjWXQzTmN6ZVE

Originally Posted by sintek

i noticed that there are occurrences of more than one highlighted cell in a row, so i am guessing that you want that row copied over only one...give this a try...

Please Login or Register  to view this content.

this works perfectly from what i wanted to happen! Thank you!
already added reputation to you!

Thanks again!

Originally Posted by sintek

Glad i could help..Tx for rep +

After trying this again, I noticed that when moving the row with highlighted cell it only copies one highlighted cell.

Please see attached photo to see what I mean.

Thank you!

Originally Posted by sintek

I don't understand...What seems to be the problem...

shtSheet1 and shtSheet2 are the two sheet that we're comparing and put the highlighted row to the shtSheet
but after comparing, it seems to be that in every row there is only one highlighted cell.

I.e, shtSheet1, A3 to E3 are highlighted but when transferred to shtSheet3 it only shows ONE highlighted cell which has to be two (name and course)

Originally Posted by sintek

I don't understand...What seems to be the problem...

do you think this has to do something with pretty big datas?

Originally Posted by sintek

Can you upload a smaller sample...Not that monster 36mb file..
What happens when you change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Do for both ranges...

I've already fixed it by adding this:

Please Login or Register  to view this content.

Thank you!