Coping data from one sheet to another below already existing data

Hi,

I would like to copy the data in a sheet named "DGFZ" to the sheet "CD". It should be copied 2 rows below the data in sheet "CD". With this macro i get the error: "This method or property is not supported by this object". The part

Please Login or Register  to view this content.

is highlighted.
How can i solve this?

Please Login or Register  to view this content.

Hi

It should be

Formula:

Please Login or Register  to view this content.

Note rather than hard code sheet tab names which are changed too easily by users, it's always advisable to use the VBA sheet names which don't change unless someone goes into VBA