Hello,
i'm new to Excel and programming and i would like some help of you.
I believe it's a simple help, however i was not able to figure out how to do this.
What i need ?
I have 2 sheets inside the same Worksheet, select a data on Sheet 2 and search the same value on Sheet 1, then i need to replace B,C & D from Sheet 2 to Sheet 1.
I'm not sure if it's very clear, i will try to use an example :
Sheet 1 (with old value)
A - B - C - D (Columns)
Invoice 001 - 250 - 311 - 423
Invoice 002 - 111 - 222 - 333
Sheet 2 (updated values)
A - B - C - D
Invoice 001 - 230 - 300 - 493
Invoice 002 - 111 - 222 - 333
So, i want to update the new value from Sheet 2 to Sheet 1, however i want to update only IF any change was mad
In the example above, the Invoice 001 had some data updated and Invoice 002 kept the same data, i want this macro to update only Invoice 001 (that has updates).
EDIT :
http://uploading.com/files/a269b148/Book1.xlsx/
Added a Sample workbook as request.
Bookmarks