Comparing two columns of data and highlighting - working but one slight issue!

Hi guys,

So I played around with the macro i posted on the previous thread, two allow me to compare two columns of data to see if they contain the same information, and have come up with the below, which works almost flawlessly:

Please Login or Register  to view this content.

The idea being that it compares the two rows of data, then in the colmun to the right puts a y or n if the data is contained in both cells. I have added in some code that related to highlighting those cells with 'n' in the allow me to see it much easier. The macro works fine, however it seems that when it runs, it will sometimes highlight random cells not in column d, for example colum g etc.

Its not a major issue, but as i'm learning, im wondering if someone could maybe explain why this occurs, and how it can be fixed?

All the best

Alex

try this:

Please Login or Register  to view this content.

I've added some code in to compare column A to column B and a third column C, to see if the text in column A is contained in either B or C.

Please Login or Register  to view this content.

So, i dont know how difficult it would be, but would it be possible to, along with highlighted the "N" in column D, to highlight the Cell where the discrepency may occur, as when comparing 3 columns it maybe useful?

Again thanks, I love learning from this forum!

Alex

So i sort of figured it out, manipulating the above code.

Please Login or Register  to view this content.

Now my next step is, after hightlighting each cell, to copy and paste the "incorrect" row into another column, so i can see a clear list of those accounts that a wrong.... I am truly stumped.

Mate, you cannot paste a 'row' into a 'column'. (not unless you mean to transpose )
You may be able to copy the complete row to a new sheet; or copy a range of cells to a new location (under new columns) in the same sheet. Try manipulating this:

Please Login or Register  to view this content.

HTH!

Originally Posted by jewelsharma

Mate, you cannot paste a 'row' into a 'column'. (not unless you mean to transpose )
You may be able to copy the complete row to a new sheet; or copy a range of cells to a new location (under new columns) in the same sheet. Try manipulating this:

Please Login or Register  to view this content.

HTH!

Appreciated!

Seeing people write code and learning form it is hugely useful to me!

Thanks again!

Alex

(PS I cant give anymore reputation to you at the moment, it wont allow me to!)