Editing macro to put the information in the correct place

I got thise code from Jerry's Excel Assistant and it was ASWESOME!!!!!!!!!!

https://sites.google.com/a/madrocket...-into-template

The only problem now is that I want the data from cells A2, B2, & D2 in the "Data" tab to be input into D3, D2, & I2 respectively into the "Survey" copied template and then A3, B3, & D3 and so on until there is no more data to be input into the same cells on the new sheet. PLease helppppppppppppp!!!!!!!!!! I think the red text is where i'm going sour.

test sheet2.xlsm

Please Login or Register  to view this content.

the syntax of those red cells are "destinationcell.value = sourcecell.value". OK? I think you're just reading it backwards;

Please Login or Register  to view this content.

BTW, when you're trying to adapt one of my macros, be sure to Private Message me a link to threads you've started for that purpose so I can join in, when possible.

Cheers.