Change Paste Starting Cell In Macro

As part of a macro, I 'copy'/'paste special' data from one section of a worksheet to another. Each time I run this macro, I would like to start the paste in a different cell. For example, the first time I run the macro I would like to copy/paste the data starting in cell A1. The next time starting in Cell C1 and the next time in cell E1, etc. How might I go about doing this?

Originally Posted by raypayette

There are many ways to do this!
You could check is A1, C1... has any data and if that is the case add 2 rows!
Note that using Cells( 1+i,1) would be more efficient than Range("A1").Select.

I'm not very knowledgeable in visual basic. The macro I'm working on was created using the auto record feature of Excel. I'd like to edit this macro so that the first time it is run, it will paste a copied set to a specified location then alter the address so that the next time it is run, the paste will be done starting at the new address. What is the syntax of the instructions needed to alter the address?
Nebb