I'll try to explain my challenge the best I can. I've attached a smaller version of my project for a better understanding.
Here goes. It is a weekly schedule. there is a "schedule" sheet and an "Admin" sheet. The Admin sheet will show a "Master List" of employees, and their total hours for the week.
The Schedule shows the employees at the top of the page with their names color coded based on the color from the "Master List" on the Admin page. It also show their total hours next to there name.
The bottom portion of the page is the schedule. I fill in the times and the hours show up in a little yellow box within that schedule day. This is irrelavent at this time.
Here's the objective: I place a name on "any" schedule day, and the cell will automatically fill the cell with the name according to the associated color on the Master List. (I'm able to do this with "conditional formatting"). This element works fine.
As I place names on the schedule (Array), the corresponding hours add up for each employee. (I used the Sumif formula for this. it works fine since I got a help from Mumps). The employees total hours show up above and on the Master List on the Admin page.
Here's my problem: If an employee is let go for some reason, that cell in the Master List becomes blank, (naturally, because I delete the name). When I delete the name from the Master List on the Admin page, elements of the "Schedule" page change properties. - some of the cells change to the color of the cell that the name was deleted from, and the total number of hours of the employee, is adding up something else. I can't figure it out.
I've also place instructions on the Admin page so you can see what I mean when I delete a name.
Sorry for the long explanation, however, I wanted to get as much detail out. (hope I did).
Thanks in advance to anyone who can understand and resolve my challenge.
Bookmarks