+ Reply to Thread
Results 1 to 1 of 1

macro to Compare ENTIRE row in NEW_SHEET.xls

  1. #1
    Registered User
    Join Date
    08-09-2010
    Location
    Chennai
    MS-Off Ver
    Excel 2003
    Posts
    5

    macro to Compare ENTIRE row in NEW_SHEET.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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1