Hi Bob and Andy,

Thanks for the quick reply. I have used Worksheet_Change function and
that seems to work.

My next problem is I need to be able to color the cell that has the
highest rank. To be more specific, the previous post showed you a
'Schedule' worksheet. I have another sheet called 'Preferences' which
ranks the program. If the Amt_Left = 0 on the Schedule worksheet, then
that means that the user has finished putting all hours for that
particular program and for each doctor. The program should then know to
go to the next highest rank.

I hope I'm making sense. Pleas ehelp.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!