create a module that copies info from one sheet to another

[geno32080]

Hello all.
I'm trying to figure out how I can have info transposed from one sheet to another without having to click a button.
When the user fills in the form (Source Sheet12) I need those select cells to be filled into select cells on the (destination Sheet7) Once the info Form is entered, saved and emailed, the form gets cleared and the process starts over. I need the info that was transposed onto the summary sheet (Sheet7) to remain, as its a cumulative summary sheet that runs for a year.
I was thinking a module? I would need it to initialize, but I'm not that good at the dim codes.

COPY source Sheet12 Cell B3 to destination Sheet7 next available row starting with B6
COPY source Sheet12 Cell C17 to destination Sheet7 next available row starting with C6
COPY source Sheet12 Cell C14 to destination Sheet7 next available row starting with D6

I need help writing the code to perform this. Anyone?

I always get the best help here, I thank everyone.

 

[geno32080]

Its a work in progress. I took the =now() code out and made it manual, what triggers your code? If I need to assign it a button to make it a Private sub its not a problem. I could incorporate it to the vaca time button, that button take the user to the summary sheet.

 

[gordsky]

Its a work in progress. I took the =now() code out and made it manual, what triggers your code? If I need to assign it a button to make it a Private sub its not a problem. I could incorporate it to the vaca time button, that button take the user to the summary sheet.
View attachment 60333View attachment 60334

my code is triggered by a change in any of the cells C14:c17 etc.
If you want the time to be the time C14:C17 is completed then just do as i said above and remove the requirement for B3 and make that equal to now()

 

[geno32080]

my code is triggered by a change in any of the cells C14:c17 etc.
If you want the time to be the time C14:C17 is completed then just do as i said above and remove the requirement for B3 and make that equal to now()

Okay, I'll work on it. I really appreciate your help, You got me steering in the right direction.
Thanks alot!.
geno