Try using the Macro Recorder........the following is a simple one that I
recorded to answer this post.......

Sub Macro1()
' Macro recorded 2/2/2007 by CRober
   Range("A2").Select
   Selection.Copy
   Range("a3").Select
   ActiveSheet.Paste
End Sub

Also, check out this link for help with macros, and post back if you have
more questions.

http://www.mcgimpsey.com/excel/index.html#usingvba

hth
Vaya con Dios,
Chuck, CABGx3