| 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. |
| 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 | |||
Threaded Mode
