Updating Celvalue in range from other worksheet

Hi,

I've got a sheet "Patientdata" and 5 other sheets for each weekday (Monday, Tuesday,...)
In the sheet "Patientdata" i've got for each patiënt 6 rows (Week, Monday, Tuesday, Wednesday, Thursday and Friday)
For each patiënt there are in different columns (each column is an hour) a therapist mentioned.
Now i want to create for each workday an overview wich therapist has to take care for wich patiënt on selected hours.
Therefore i've created 5 sheets for each weekday.
Column C contains the different therapists, Column K to Y are the appointmenthours.
At this moment i've got a problem with adding (multiple) values to a cell depending on Therapist, Patiënt and appointmenthour.
My code don't add the patient to the selected cell. (If there is already another patiënt it has to add the new patiënt on a new line in the same cell because a therapist can handle 2 or 3 patiënts at the same time)
This last part isn't in my code yet because the first part don't work.
Is there anyone who knows what's wrong with my code?

Please Login or Register  to view this content.

Thanx
Jan