Eric Carolus
New Member
Hi Folks
I have two sheets in the attached workbook.
These are called Teachers and Allocation.
I have a dynamic range called Educators on the sheet called Teachers.
This dynamic range is also the LIST for the sheet Allocation.
Click on the columns E9:E38, G9:G38, I9:E38, etc, etc.
On the sheet Allocation, the first three educators had been selected.
Now the problem, whenever a teacher is DELETED on the sheet called Teachers,
I wish for the educator name to be removed on the sheet Allocation (E9:AP38)
(Of course the educators name will be removed from the drop down list in each cell on the sheet Allocation)
I have no idea where to start.
Can someone help please?
Thanks in advance.
Eric
I have two sheets in the attached workbook.
These are called Teachers and Allocation.
I have a dynamic range called Educators on the sheet called Teachers.
This dynamic range is also the LIST for the sheet Allocation.
Click on the columns E9:E38, G9:G38, I9:E38, etc, etc.
On the sheet Allocation, the first three educators had been selected.
Now the problem, whenever a teacher is DELETED on the sheet called Teachers,
I wish for the educator name to be removed on the sheet Allocation (E9:AP38)
(Of course the educators name will be removed from the drop down list in each cell on the sheet Allocation)
I have no idea where to start.
Can someone help please?
Thanks in advance.
Eric