I have an excel sheet that I am attempting to apply restrictions to and also requires a drop down list.
End Goal: I want to make it to where a user has to select a cell in COLUMN A, choose a value from a drop down list (drawn from COLUMN D), before inputting any data in the corresponding cell in COLUMN B.
So far, I have set a data validation that restricts data being entered into COLUMN B if the corresponding cell in COLUMN A is blank. I have set it to where a warning pops up and tells the user what they need to do before inputting that data.
Where I am stuck is if the user inputs data in COLUMN A and then COLUMN B like I want, if the data in COLUMN A is deleted for whatever reason, there is nothing stopping the value in COLUMN B from remaining.
I'm looking for a way to restrict it both ways (avoiding using macros), but still keep the drop down menu.
<tbody>
</tbody>
Any help is appreciated
End Goal: I want to make it to where a user has to select a cell in COLUMN A, choose a value from a drop down list (drawn from COLUMN D), before inputting any data in the corresponding cell in COLUMN B.
So far, I have set a data validation that restricts data being entered into COLUMN B if the corresponding cell in COLUMN A is blank. I have set it to where a warning pops up and tells the user what they need to do before inputting that data.
Where I am stuck is if the user inputs data in COLUMN A and then COLUMN B like I want, if the data in COLUMN A is deleted for whatever reason, there is nothing stopping the value in COLUMN B from remaining.
I'm looking for a way to restrict it both ways (avoiding using macros), but still keep the drop down menu.
A | B | C | D | |
1 | Type | Data | Data List | |
2 | ||||
3 | 1 | 10 | 1 | |
4 | 2 | 20 | 2 | |
5 | 3 | |||
6 | 4 | 40 | 4 | |
7 | 5 | 50 | 5 | |
8 | 6 | |||
9 | 7 | |||
10 | 8 | |||
11 | 9 | |||
12 | 10 |
<tbody>
</tbody>
Any help is appreciated