Compare entrie row and update only status in NEW Record.

[vsugadev]

Hi All, [I have attached same files]
I want to write a macro to Compare ENTRIE row in NEW_SHEET.xls.If any records present in OLD_Sheet.xls.Our macro should update Only Comments column [P:P] value in NEW_SHEET.xls status field.
=================================================================
IF (Any OLD_SHEET Record present in NEW_SHEET) then
{
Update NEW_SHEET.COMMENTS= OLD_SHEET.COMMENTS

}
Else
{
Print "NEW RECORD" in NEW_SHEET.COMMENTS
}
=================================================================
Thanks
Sugadev V.

[JBeaucaire]

original question changed.

[vsugadev]

At first glance, it appears the ONLY value in the "Query Status" column is "Answered", so any updates between the two sheets would change nothing.

Please provide sample sheets with actual examples of data needing updating, point out those examples specifically so we know where you're looking and what you expect to change.

Hi JBeaucaire,
Thanks for the reply. Sorry, we have to refer COMMENTS column not "Query Status" column.
=============================================
IF (Any OLD_SHEET Record present in NEW_SHEET) then
{
Update NEW_SHEET.COMMENTS= OLD_SHEET.COMMENTS

}
Else
{
Print "NEW RECORD" in NEW_SHEET.COMMENTS
}
=============================================

Thanks
Sugadev V.