seldom excel
New Member
- Joined
- Jul 2, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello,
I am an excel novice, and need help with my Job Tracking sheet.
Basically what I want to happen, is when any of the "L" cells are changed to "Yes", the contents of cells "B" through to "L" are cleared... I have it set so that "Yes" is selected from a drop down menu and not manually entered.
I am hoping this is possible and not too difficult... I hope I have explained myself well enough, and thank you in advance for any help offered.
I am an excel novice, and need help with my Job Tracking sheet.
Basically what I want to happen, is when any of the "L" cells are changed to "Yes", the contents of cells "B" through to "L" are cleared... I have it set so that "Yes" is selected from a drop down menu and not manually entered.
I am hoping this is possible and not too difficult... I hope I have explained myself well enough, and thank you in advance for any help offered.