copying a group of cells and pasting them below that group

[merrittr]

I was wanting to , via VBA or macro be abble to add multiple groups fo cells that pertaing to an individual client each

 

[paulxmw]

here is the answer to the query in the title of your post

    Sheets("Sheet1").Range("A1:A10").EntireRow.Copy Destination:=Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)

Paulxmw