Hello,
If problem excel
If cell H of worksheet A = cell E of worksheet B
and/or
If cell J of worksheet A = Cell H of worksheet B
and/or
If cell K of worksheet A = cell I of worksheet B
then copy cell O of worksheet A to cell L of worksheet B
(put in other words
if H2, J2, K2 of worksheet A = E1, H1, I1 of worksheet B
then copy O2 of worksheet A to L1 of worksheetB)
if H3, J3, K3 of worksheet A = E5, H5, I5 of worksheet B
then copy O3 of worksheet A to L5 of worksheetB)
i need the macro to match and copy for the whole worksheet of A and B
Data from worksheet A is only to be used once
Configuration: Windows Vista Internet Explorer 7.0
I tried to do something like this but nothing seems to get copied...
|