Unanswered: help - replace field with other value from another sheet
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
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 04:36.