copying the cell comments of one sheet to other sheet

[Arjun T A]

Hello every one,

I have an excel which contains two sheets "DCW" and "DCW Original" the number of columns and rows keep changing , in the sheet "DCW" the first column ie "ColumnA"contains the values "Mismatch" or "OK" for each row, all the rows in the "DCW" will be present in "DCW Original" but "DCW Original" might contain many rows.

now, i want a macros where if the "ColumnA" value in the sheet DCW is "mismatch" then it should search for the same row of the "DCW" in the "DCW Original" and it should copy the cell comments of that particular row from "DCW" to "DCW Original".

since the "columnA" of the sheet "DCW" contains Mismatch or ok , the row data starts from "columnB" but in "DCW Original" the row data starts from "Column A"

 

[Andrew Poulsom]

What do you want to use to "search for the same row of the "DCW" in the "DCW Original"?

 

[Arjun T A]

What do you want to use to "search for the same row of the "DCW" in the "DCW Original"?

It should identify based on all the cell values of that particular row , since the DCW original contains the same row with same cell values.

 

[Andrew Poulsom]

How many columns? Is there a column that contains a unique value that can be matched?

 

[Arjun T A]

How many columns? Is there a column that contains a unique value that can be matched?

The number of columns keeps changing and there is no column which contains unique value ,it should check all the cell values of each row in DCW with all the cell values of each row in DCW Original if its a match then it should retrieve the comments.