userform with looping code

Yes, we would not need the diminishing validation lists, in this case...

If we can allow more than one entry per day then we could flag the log to indicate shifts or break-downs/down time, then produce tables to indicate each scenario

I am thinking that although I agree there could be some benefits to your ideas, it would be unnecessary, as duplicating this file would be just fine. As another user would ultimately be in control of filling out the data for their respective shift, and I would rather restrict their access to just one shift's information.

1/. How many shifts do you have in a working day? 22/. Are all lines running at any one time? Sometimes but usually not

Other Ideas

• Could we move the "Input Attendance" form down to row 500
• Hide the first 500 rows, so it appears that the Input Log is at the top of the sheet, and then in each Column have the cells automatically reference the names inputted into the "Lookups" NameList? Remember this list will change weekly so it will have to be versatile, and there will never be more than 500 employee names on that list.
• We could then hide the Gridlines, and Headings on this worksheet.

That way when I started typing them they would be there? I mention this option for convience of the data entry, but I also like the drop down as well, as maybe the name is unknown or unrecognized. I do not want to get rid of the Lookup sheet, as it will be convenient to change where it is. Just a thought, what do you think?

Also this another small issue, I dont know what "Rota" is can we change this to "Entry" or "List"