1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Replace current field with value of another

Discussion in 'VBA Macros' started by Frank Bacchus, Aug 9, 2018.

  1. Frank Bacchus

    Frank Bacchus Member

    Messages:
    153
    On a weekly basis, I get 2 new data files (Sample1 and Sample2). Sample1 is the full file (lots of data) and Sample2 a smaller file with a subset of data. The fields in Sample1 are in columns A=Key, B=Resolved. The fields in Sample2 are columns A=Key, B=Issue End Date.
    I would like to create a macro that I can envoke that would use the key from Sample2, and find the record (same key) in Sample1 and replace Sample1's cell B (Resolved) with Sample2's cell B (Issue End Date). This is done after I receive the two files.


    I have included 1 spreadsheet with (1) Sample1 (2) Sample2 and (3) Result set

    Thanks in advance

    frank

    Attached Files:

  2. Belleke

    Belleke Active Member

    Messages:
    461
    Hi,
    Something like this?

    Attached Files:

  3. vletm

    vletm Excel Ninja

    Messages:
    4,163

    Attached Files:

Share This Page