| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro: Copy data to another sheet
Per Jessen skrev:
Hi Anders M38:O49 = 12 rows AB3:AD12=10 rows only Sorry, my mistake. Wrote the wrong numbers :-) Sub AddMatrix() Sheets("Sheet1").Range("M38:O49").Copy Sheets("Sheet2").Range("AB3").PasteSpecial Operation:=xlAdd End Sub Works like a charm! Thank you. Anders |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1 Create a macro to Copy & paste certain data to another sheet | Excel Discussion (Misc queries) | |||
| Macro to copy a sheet and name it | Excel Discussion (Misc queries) | |||
| Macro to copy data from One sheet to another | Excel Discussion (Misc queries) | |||
| Macro: Insert, copy and past data from sheet | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
![Anders[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
