Add multiple rows to table for timesheet/timetable management

[aledre]

Good morning,
I have been following you for some time and I steal some advice for some scripts, but now I need more help.
I have a worksheet like attached file, where in the first sheet I have a table with the list of employees and the times of entry and exit. I need a script that adds the times I fill out every day to the end of the database sheet. With the macro below I can add a row, but the number of employees can change and some days some times can be empty. How can I avoid adding empty rows and only adding rows with compiled data?

With this script I cand add a single row... Need to copy that script for each row?

Please Login or Register  to view this content.

[gue2013]

you can do the whole in one

Please Login or Register  to view this content.

Please be aware that there is no error handling included. Also if you call the macro twice you have doubled your dataset (duplicates).

cheers,
Guenter

[vcoolio]

Hello Aledre,

Here is another option:-

Please Login or Register  to view this content.

This is a worksheet_change event code and needs to be placed into the worksheet module. To implement this code:-

- Right click on the "Inserimento" sheet tab.
- Select "View Code" from the menu that appears.
- In the big white code field that then appears, paste the above code.

I've attached your sample workbook with the code implemented.

In an attempt to simplify this for you, you'll see that in Column P ( I've just named this column "CHECK") of the "Inserimento" sheet I have placed a Yes/No drop down box in each cell (you'll obviously only need to select "Yes"). Once you are happy that all cells in any row are properly filled in, select "Yes" and move on to the next row. You'll notice that as soon as you select "Yes", the row of data will be transferred to the "DATABASE" sheet instantly.
This will happen row by row only and when and if you decide that any row of data needs to be transferred over.

I hope that this helps.

Cheerio,
vcoolio.