| 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) | |||
Linear Mode
