Macro for multiplying the # of rows 3 times and adding add. information in new column

Hello,

I am new both in this forum and using VBA. Maybe someone could help me with the code for the problem I am facing.
Gut feeling says that it should be very easy; though, I can not manage to solve it on my own for the second day by now

I am trying to create a macro for a task that needs to be performed very often. The problem is that the # of rows of data needed to be processed varies every time.
I have attached the excel template of the problem.
The active cells (except headings) from the columns A:B; the work sheet "Data source", should be copied to the sheet "Data after transformation" 3 times; 2nd and 3rd time placing copied columns under previously copied columns. Then data from column C (active cells, sheet "Data source", except headings), should be copied to the sheet "Data after transformation" to the column C. Next to this data in column D, the name Axxx should be repeated (the number of times Axxx is entered is corresponding to the # of newly entered cells in the column C). The same should be repeating while moving data form columns D and E (from sheet "Data source" to sheet "Data after transformation" to column C) and adding names Bxxx and Cxxx in column D, sheet "Data after transformation".

Hopefully someone could help me with this question.

Donata

You could use this macro:

Please Login or Register  to view this content.

Regards,
Antonio

Thank you for the help!
While Antonio's macro seems to work well, when I try to use the one offered by Patel, the error #400 shows up.
Maybe you know, what could be the reason for this?

Wish you a nice evening

Thank you - it works