Mandar Khedekar
New Member
Write macro to copy data from Source File to assignment-2 file. Make sure you take care of following conditions
• Book with same name should not added to the destination, instead only its other fields should be updated
• Leave the Author column from source file; need not have to be copied.
• new book record found in the source file needs to be added at the last available row in Destination file.
• after copy of data, if I click on “Refresh Graph data buttons” then it should refresh data considering additional records.
please note:
Assignment2 file has table with three 4 columns Book name, Author, Number of copies, price.
• Book with same name should not added to the destination, instead only its other fields should be updated
• Leave the Author column from source file; need not have to be copied.
• new book record found in the source file needs to be added at the last available row in Destination file.
• after copy of data, if I click on “Refresh Graph data buttons” then it should refresh data considering additional records.
please note:
Assignment2 file has table with three 4 columns Book name, Author, Number of copies, price.