Excel 2007 Macro - Search, then Replace

[Azeon]

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.

[arlu1201]

Please attach a sample workbook so we can help you better.

[Azeon]

Please attach a sample workbook so we can help you better.

I upload a file as an example.

Thanks!

[arlu1201]

That link takes me to a site to download the file for a charge. Please attach the file on the forum itself.

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Azeon]

That link takes me to a site to download the file for a charge. Please attach the file on the forum itself.

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

Done,

Sorry for the trouble.

[kvsrinivasamurthy]

Pl see attached file.It may help you.Views are welcome.
With regards

[arlu1201]

I was trying your code kv and found that i does the reverse. It updates sheet 2 with values from sheet 1.

[Azeon]

I was trying your code kv and found that i does the reverse. It updates sheet 2 with values from sheet 1.

And also, if i add new data from Sheet 1, it will not update on Sheet 2.

But Thanks for the help anyway Kv.

[kvsrinivasamurthy]

Pl see attached file.It updates data from Sheet2 to Sheet1.

[royUK]

Please don't clutter the Forum by quoting whole posts