I am attempting to run a loop which takes cell A1 and
tries to locate matching cell (e.g. B35) then replacing
D1 with C35. Any thoughts on how to write this in a
macro in Visual Basic??