Attendance Register with Excel?

This worksheet makes use of tables and overlaid named dynamic ranges (sounds scary but it isn't). The first (blue) table is where the work is done, and it runs the pivot table in Columns E & F. The workers are in Column J and the Sites in Column L.

There are a couple of reasons for using tables:

They know how big they are so using them as a source for a pivot table or writing formulas based on them means you don't have to change the formulas or data source when data is added or deleted.

They automatically "copy down" formulas formatting and validation.

You can remove a table row (right click on the row(s) to remove and select delete -> table row) and it will not affect other data in other columns on that row.

There is a before change event that expands the Work (Blue) Table when you select the cell immediately below the last name in the table. There is a data validation that gives you dropdowns for the name and for the sites.

The only thing you have to remember to do is refresh the pivot table.

I do not prevent you from trying to enter the same person twice, but I do give you a warning in column C. It will say "Duplicate."

Here is more information on dynamic ranges and tables.
http://www.utteraccess.com/wiki/inde...ables_in_Excel
http://www.utteraccess.com/wiki/inde...Dynamic_Ranges

Here's a modified version that also includes date.

P.S. You can keep the running total of who is assigned to what site using another pivot table off the same set of data.