To record a macro:
go to Tools, Macro, Record New Macro.
A dialogue box will open where you can name your macro and designate key strokes to run it. From then on every action you take will be recorded in code. Just select the area you wish to copy, then select the workbook and worksheet you want it to go to and paste it. Press Esc on your keyboard (ends copy mode)
go to Tools, Macro, Stop Recording.
Now when you use your designated keystrokes the macro will copy from the same range and paste to same range exactly as you recorded it.
If you wish you can assign this macro to a button. You do this by customising your toolbar. Select the button icon from the Forms section. Click on this icon to draw an oblong button on your sheet. Right click the button and select Assign Macro. select your macro's name.
Hope this helps
regards
Derek