Hi John,
Thank you. It's very close to my requirement. I have made a little amendment in it to clear 2 columns to the right if the user edit State.
Requirement:
If the user edit State clear 2 columns to right. That is District and Block.
If the user edit District then clear 1 column to left and 1 column to right. That is State and Block.
If the user edit block then clear 2 columns to left. That is State and District.
In short I want to select the drop down list from column 'J' to 'L' direction only. User can not edit the drop down list from District or Block.
Please tell me what is the meaning of
Thank you.
Bookmarks