How to copy a group of cells automatically

[maramkarthik]

Hi,

I stuck with a situation where i am having a group of cells with some data starts from a1 to e23 cells in the current work sheet.

Question 1) If i say to replicate the above group for 9 times in the current work sheet, then excel should create a copy of above group for 9 times in a new work sheet.



Please provide me a solution to achieve this with out working manually.

[kvsrinivasamurthy]

PL see attached file with macro & button.