workSheet.Cells[1,5,100,5].Copy(workSheet.Cells[1,2,100,2]);
Copies column 5 into column 2 Basically Source.Copy(Destination)
This would only copy the first 100 rows.
Cells[RowStart, ColumnStart, RowEnd, ColumnEnd ]
is the format so to copy a row into another row you would just switch the indexes accordingly