Hi,
I have created 4 conditional drop down lists on a worksheet. Upon changing a cell in column S, I need the related column T to be cleared. This is to ensure that the user chooses a relevant item from the list in column T once he/she changes column S. The related cells are S15:T15, S19:T19, S20:T20, S21:T21.
I have used the following code to manage this action for cells S15:T15:
I have tried various changes to apply to the other cells as well, but have been unsuccessful. Can someone please help me with the correct code?
Thank you,
Corneli
Bookmarks