Clear multiple adjacent cells with Offset

[sadyr]

Hey Guys,

Trying to implement the following: I have 4 columns (C,D,E, and F). If a user inputs any data in any cell in ColumnC then Column D is automatically filled with value "Y". I was able to implement this part, which works ok. What I need to do now is when user inputs any data in any cell in column E (let's say E4), then corresponding cell in column D (D4) or column F(F4) needs to be cleared (meaning that there can be only one "Y" value in the row between D4 and F4). And if Column C is empty, then Columns D, E, and F are also empty.

Woooph, I hope you understand what I need to implement, if not, pls ask for more info. Below is the starting code:

Please Login or Register  to view this content.

Any suggestions and thank you!

[xladept]

Maybe:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

[sadyr]

Hi XLAdept, unfortunately, it didn't work. And what did you mean by "You can't do one thing"?

[xladept]

"You can't do one thing" is my paraphrasing of the Heisenberg principle from Physics wherein just by measuring something you have changed its nature. I find it particularly appropriate for programming as any change made to pre-existing code will, most likely, alter something else down the line and scramble the logic of an algorithm

What do you men by "It didn't work"?

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic