L
Lillian Lian
I have one excel spread sheet with sheet1 and sheet2, they both only have
columnA,
on sheet1 as following:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
on sheet2 as following:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
so sheet2 has (e-mail address removed), sheet1 does not have this.
so how to write the macro match this two sheet1 and sheet2 columnA and have
result (e-mail address removed) show up on sheet1
thanks
Lillian
columnA,
on sheet1 as following:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
on sheet2 as following:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
so sheet2 has (e-mail address removed), sheet1 does not have this.
so how to write the macro match this two sheet1 and sheet2 columnA and have
result (e-mail address removed) show up on sheet1
thanks
Lillian