VBA copy and paste multiple times

[duplaly]

Hi
I'm trying to copy a date in range("a2") from worksheet "a" and paste it to worksheet "b" 10 times starting to first blank row.
Everytime i run the macro, i want the date to be added allways starting to the first blank row.

Appreciate any help!

 

[footoo]

Worksheets("a").[A2].Copy Worksheets("b").Cells(Rows.Count, "A").End(3)(2).Resize(10)

 

[duplaly]

Hi
I have attached my project in order to illustrate my request.
I would like to copy the data from the CUTOFF sheet to the DATABASE sheet according to the illustration

Thanks for your time and help!