Have a look at the MS Excel VBO, as there are a range of actions already built that will let you do this.
""Copy and Paste Worksheet Range""
Combination of ""Select"", ""Copy"" and Paste""
Combination of ""Get Cell Value"" and ""Set Cell Value""
Probably a number of other ways you can do this using the existing actions.
