How do delete or insert values in another cell based on validation selction in adjacent cell
Okay here is where I am at:
My friend and I are trying to creat a NCAA basket ball bracket in excel. I am using validation dropdown lists to popolate the cells and then a second worksheet to create a new validation list for the next round based on what was selected previously. This works great but I want to add the additional functionality that if they select someone in round of 32 then select the same team in the sweet 16 to win but decided that the team would actually lose in the previous round that any rounds after that would clear the name since it was selected to lose prior to that. I am not sure if there is a way through VBA or someother method to make this happen.