Macro to copy cells from one worksheet to another

[Kirby]

Is there a code that will copy specific cells from one worksheet to specfic
but different cells on another?
EX: If B3 is updated on sheet1 I want to copy b3 to b6 on sheet1 into
specific cells in sheet2 - b3 to f2 / b4 to f4 / b5 to c10 etc?

 

[ShaneDevenshire]

Hi,

yes, but we would really need to know more to be very specific, here is the
general idea:

Workbooks("Target.xls").Sheets("destination").Range("A110") =
Workbooks("Source.xls").Sheets("myData").Range("M1020")


If this helps, please click the Yes button.