Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2013
    Posts
    1

    Unanswered: help - replace field with other value from another sheet

    Hi there,

    I'm just registered to this site. Sorry for my bad introduction.

    here i need help about macro in excel. I user excel 2007.

    I have workbook with 2 sheet.
    sheet1 contains 3 columns, A,B,C
    sheet2 contains 2 columns, Y,Z.
    type of all colums is text.
    I want to replace value in column A with value column Z and C
    where value column A = Y
    example:
    column Y
    id1
    id2
    id3

    column Z
    newid1
    newid2
    newid3

    if on cell A1 found value "id1" then replaced with:
    "newid1" + (value in cell C1)

    and so do with other row. is this possible to make macro for this?
    please help me. thanks.
    Last edited by supjb2; 11-15-13 at 05:36. Reason: revision

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •