I have 2 sheets Form_ERR and DataBase_ERR.
Form_ERR has: -
Cell L11 - where a number can be entered
Cell L14 - dropdown selection containing Names
Cell L16 - dropdown selection containing Categories
Cell L18 - dropdown selection contain Departments
Cell L20 - dropdown selection containing...