Copy and paste macros???

So I am creating a voice mail log for my department and when a teammate completes the task of returning a clients call they can click the button I have created and it will automatically fill in the current date and time for tracking purposes. Here is the code I am using:

Please Login or Register  to view this content.

Problem is that is the code for one button and for one record. We have anywhere between 100 and 200 voice mails to return each month. Is there a way that I can copy the entire row to include the button and the VBA so that the next line will look like this:

Please Login or Register  to view this content.

and so on all the way down? I know if I select the cell and grab the bottom right corner and drag it down it will copy the cells however the VBA does not come with it as I had hoped like a regular formula would.

Any help is much appreciated!

You do not need to have 1 button for each entry.

You can have just 1 button with this code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

@ts try this one I just edited the macro created by arlu1201 to copy the format of the first row
and also I eliminated the button and assigned ctrl+shft+q to do the task I guess you don't need the macro for this you can use keyboard express instead. credits goes to arlu1201. thank you.