Calendar for with employee names under the day their evaluation is due

This sounds like a job for a pivot table. Make a copy of your spreadsheet, Change the real names to fictitious ones. (Hint: type in Name 01 and drag it down). Then attach it here. Once we see how the data are organized we should be able to help better.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

This wasn't quite what I thought it would look like. This application would best be done in a database. Excel can be programmed to look like a database, but you have to write code to add, change and delete records: something databases do automatically.

This is a lot bigger project than it looks. First you need several tables:
- One with employee information
- One with level information (number of months to evaluation)
- One with historical information

Instead of adding a sheet every time you have a new employee, you would add information to the employee information file. Then when when you need to update employee information, you pull up a blank template that is populated by code by pulling data from the database. You fill in the data and press a button to commit it. The program then has to decide what data has changed and find the appropriate records and either change them if it's a change or append new records if it is new data. Do-able, but complicated.

I'm sorry, but I'm going to have to pass on this one.

I get the feeling that your a small company so MS-Access could work. There would still be some programming involved but most of the work would be in form design - pulling in the pieces for display.

Check on this board in the MS-Access section or you may even think about the commercial side of this board.

I will also put in a plug (I hope it is allowed) for a board I've been a part of that in 95% devoted to Access (and a very small Excel section). It's 100% non-commercial: utteraccess.com. I go there for my Access questions and come here for Excel.