View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eddy Stan Eddy Stan is offline
external usenet poster
 
Posts: 151
Default 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