I need a macro built for this spreadsheet.
There are three columns:
1. Job Family (F)
2. Discipline (G)
3. Subdiscipline (H)
Discipline and SubDiscipline have a cascading dropdown list that's driven by the Job Family that's selected.
I need two things to happen with this spreadsheet
1. If a discipline is selected, but the subdiscipline is blank, not allow the file to save.
Popup message, "You must select a Subdiscipline before saving the file.
2. If someone selects a discipline and a subdiscipline, but decides to change the discipline, I need the subdiscipline to blank out. (If not, then the subdiscipline will remain as previously selected.)
All this data will be loaded into SAP and these are the rules in SAP, so we want to have the data as clean as possible for the upload, else, the records will error out.