Help to find and replace between sheets
Hi all,
i have 2 sheets as below
column c J
row 6 511 285
row 7 285
row 8 422 625
sheet2 col b m
row 100 510
row 105 511 285
row 120 282
row 125 285
row 800 422 625
find sheet1 511 and 422 in sheet2 (because value next to them is 0) then
put next to them 285 and 625 in sheet2 from sheet1
thanks in advance
regards,
Eddy stan
|