Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Compare ENTRIE row in OLD_Sheet.xls and Update the Comments Column Value in NEW.xls
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. |
#2
|
|||
|
|||
Quote:
This can be achieved with nested loop in VBA. For each Row For each Cell (Do Compare and Report Thing) Next Cell Next Row Obviously you will need some unique identifier such as an account No. to match. Educo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning multiple text data into 1 column from many column entrie | Excel Worksheet Functions | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
How to Autonumber Rows but Retain Same Number for Duplicate Entrie | Excel Discussion (Misc queries) | |||
Compare and update spreadsheets | Excel Discussion (Misc queries) | |||
Compare and Update elements from Sheet1 with Sheet2 | New Users to Excel |