View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnM JohnM is offline
external usenet poster
 
Posts: 27
Default Find value from one sheet and replace value in second sheet

I am trying use VBA to:

locate the value that is in Sheet"a" column b, row 2
in Sheet"b" then
replace value in Sheet"b", column J with value from Sheet"a" column K

increment to Sheet"a" column b, row 3
Find matching value in Sheet"b"
replace value in Sheet"b", column J with value from Sheet"a" column K

Thanks in advance,
--
JohnM