command button to move data to new sheet in workbook

I am currently working on a workbook to track the build sheets of a product. And would like a command button added. That the user hits after they enter all the data for the product built.
I have 6 cells on the main page that I would like to move to the new sheet
I have been watching you tube videos on how to get this done and seem to have hit a dead end.
I have attached a copy of the workbook I am working on.
Here is a sample of the code I have.

Please Login or Register  to view this content.

nevermind, i read your question wrong.

Thank you very much! that is what I needed.
good thing from all of this is my boss wants me to take a course in advanced Excel. he is paying.

Originally Posted by Winon

Hello tjdarla,

Maybe something as per the attached Workbook?


Regards

Winon beat me to it but here is another way..

I think they both work well. I do like what Winon has that it jump to the sheet the data is stored on. our plant hands would just keep pushing the command button thinking it isn't doing anything and would keep adding he same thing over and over.

but thank you both for your help with this