copy and paste data from one worksheet cell to another using command button

hi guys,

need some help here on copying data from cells on one worksheet to another worksheet on the same workbook. i tried to search around but still could not find which is the best to solution.

here is a short detail of what i want to do:

worksheet 1 (input):
i have a range of cells divided into fields which contains data. these fields are the same on worksheet 2 (which serves as my database sheet)

problem: i want to create a command button which after clicking would copy the data from worksheet1 to corresponding fields in worksheet2.
(anybody can help with formulating the code?)

i have attached the file i was working with for easier reference.

hoping someone can help with this.
thanks very much.

Hi jasonruiz,

Put this into a module, then assign it to the button you have on your sheet.

I have made the assumption that you want to move down a row after every entry so that you don't overwrite data.

Please Login or Register  to view this content.

What will you do if the DBase sheet needs to extend past 39 rows however? You currently have a signature line down here. If you moved this to the top of the sheet, you could keep moving down with a slight amendment to the above.