Results 1 to 10 of 10

Excel 2007 Macro - Search, then Replace

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    4

    Excel 2007 Macro - Search, then Replace

    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.
    Attached Files Attached Files
    Last edited by Azeon; 11-04-2011 at 10:57 AM.

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