Copying from one sheet to another

[ajbryant]

I want to copy from one sheet to another and then continue to have it copy to the next row after rather than replacing.

Code:
Sub cablef()

Range("C8").Select
Selection.Copy
Sheets("Cable Fab").Select
Range("C19").Select
ActiveSheet.Paste
End Sub

I want it to copy to range C20 next time but copy from C8 still. Is there a loop I can run?

[Sadath31]

How is the looping pattern
ie first copy from C8, second time copy from C20, third time ???
or may be you have value in C8 and next value cell is in C20 and then copy next value cell in column C , so on...

please explain