Hello all!

I have just finished an attendance tracking spreadsheet for the agency that I work for. The basic sheet layout is as follows:
  • Setting- Allows for changing the year, user defined holidays and auto populating US holidays into the calendars on the months sheets based on year throughout the spreadsheet
  • Attendance Calendar-Displays specific employee and attendance data via a drop down list by employee ID #
  • Reports- Various reports on employee strength by department
  • Employee Data- ID #, Name, Title, Department, Hiring Date, Mil or Civ
  • 12 Months- sheet for each month of the year, employee data is auto populated into each month via the IF command

I have tweaked this spreadsheet the way I want it and am happy with the way it works. What I am wondering is if I can create a USERFORM that is separate from this spreadsheet so that it can be emailed to each department head. The department head will fill out the employee via a drop down list on the form, then input a specific attendance code such as P or S. The date will either be input manually or auto populated. This daily completed form will then be emailed back to the person tracking attendance company wide and that person will merge the attendance USERFORM data into the correct month sheet and date.

I am trying to make data entry a minimum for the person tracking the attendance with the spreadsheet. The person tracking the attendance currently has plans to just email the spreadsheet around and have the department heads fill in the attendance data. While this will work, it is slow, has privacy concerns and is susceptible to data integrity issues. This is why I want a USERFORM so that the data can be reviewed before being merged into the spreadsheet. Is this possible?

Thanks for taking the time to read/respond!