Copy data from one sheet to another

Hi Guys,

I would like to make my daily routine more efficient with the help of macros, but i'm fairly new to it, so hopefully somebody will be so kind and will help me on this project.

Basically i have a workbook with three sheets ("Data", "Entry" and "Database"), in the "Entry" sheet i would like to with a press of "Update" button copy the data from the "Data" sheet into a table based on the order number, after that i will fill all required fields and by pressing the "Send to DataBase" button copy all data to the "DataBase" sheet next empty row.

I have attached the workbook where i have explained in more details how these codes should work.

If somebody can help me on this that will significantly decrease the amount of time i spend on it every day, i really appreciate your time.

Thanks in advance

Your first button is an activeX button so put this code for the button

Please Login or Register  to view this content.

Your second button is a form control button so assign the macro Send_to_Database to it.

Please Login or Register  to view this content.

Hi stnkynts,

Great thank you very much. Only one thing it does not copy the data from the comboboxes in "Entry" tab.

Can you please adjust the code to copy as well the text from comboboxes?

Thanks a lot

Please Login or Register  to view this content.

Thanks a lot works as charm