Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to copy cells from one worksheet to another
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? -- Thank you in advance Kirby |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to copy cells from one worksheet to another
Hi,
yes, but we would really need to know more to be very specific, here is the general idea: Workbooks("Target.xls").Sheets("destination").Rang e("A1:D10") = Workbooks("Source.xls").Sheets("myData").Range("M1 0:P20") If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Kirby" wrote: 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? -- Thank you in advance Kirby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Macro to Copy from Worksheet | Excel Discussion (Misc queries) | |||
Macro to copy worksheet | Excel Discussion (Misc queries) | |||
Want macro to select & copy cells from a different worksheet | Excel Discussion (Misc queries) | |||
I need help with a macro which will copy a worksheet and.. | Excel Worksheet Functions | |||
How to copy subtotalled cells to a new worksheet (in a macro), wi. | Excel Discussion (Misc queries) |