Macro to copy cells from one worksheet to another


K

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?
 
Ad

Advertisements

S

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("A1:D10") =
Workbooks("Source.xls").Sheets("myData").Range("M10:p20")


If this helps, please click the Yes button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top