08mcrisp
07-19-2011, 11:24 AM
Hi,
I need to make a macro that cuts range ("C1:E57") and pastes it to ("Sheet1") in the active cell and then moves the active cell one place to the right so that the next time the macro is run, the data that is in ("C1:E57") can be pasted next to the last set of data in ("Sheet1").
I am a complete beginner at macro but I had a go at it:
Sub NewYear()
'
' NewYear Macro
'
' Keyboard Shortcut: Ctrl+n
'
Range("C1:E57").Select
Selection.Copy
Sheets("Sheet1").Select
Offset(0, 1).Select.ActiveSheet.Paste
End Sub
This (of course) did not work but I have no idea what to try now!
Please help me!
Thanks and regards
08mcrisp
I need to make a macro that cuts range ("C1:E57") and pastes it to ("Sheet1") in the active cell and then moves the active cell one place to the right so that the next time the macro is run, the data that is in ("C1:E57") can be pasted next to the last set of data in ("Sheet1").
I am a complete beginner at macro but I had a go at it:
Sub NewYear()
'
' NewYear Macro
'
' Keyboard Shortcut: Ctrl+n
'
Range("C1:E57").Select
Selection.Copy
Sheets("Sheet1").Select
Offset(0, 1).Select.ActiveSheet.Paste
End Sub
This (of course) did not work but I have no idea what to try now!
Please help me!
Thanks and regards
08mcrisp