I wish to CLEAR the (specific) contents on one sheet 1 (huge range) if that specific info had been DELETED on sheet 2 (a dynamic list).
My experience in coding is not not that good at all.
I code by looking for similar examples on Google.
Let me explain. I have a workbook with two sheets, called Allocation and Teachers. On Teachers is a DYNAMIC LIST called Educators.
Whenever a DELETE a name (given by NM, JH , etc.) from the dynamic list (on the sheet called Teachers), ALL CELLS that contain instances of the DELETED name,
on Allocation, must be CLEARED of its contents.
The range on Allocation (from which the name (i.e. NM, JH, etc. must be cleared) is F9:OP38.
I have slapped together 2 Subs in Module 1, but neither of them works.
Thanks again for your patience.