Micro

this pic shows information moved from another sheet using micro vba how do i get it to move over to the next colum when i put more info in.  his is one of the codes im using. Worksheets("C...