How to save multiple data from one sheet to another, and to update multiple data and save again to database.

[HR Jonas]

Hi I badly needed your expertise to help me create a payroll system.

I have two sheets; Sheet 1 is where I input the time data of employee and automatically computes. Sheets 2 is my database where all values are saved.

First question, how do I save data in a multiple row from one sheet (Sheet 1) to another (Sheet 2), but I only want to save up to the last row that has values.

2nd is, if I already saved the data to database and I want to update it (let's say I have made an error encoding the time data but I already saved it), what code for this.

What I only know is how to save and update a data that is in a single row, but when I have to save/update a data of multiple rows, I am having a hard time on it.

Hope you can help me. Thank you in advance

 

[sijpie]

can you post an example of your sheet1? highlight which rows are to be copied.
If you edit data, how will the macro recognise which row it relates to?
Would the data need to be cleared from sheet1 after the copy?