paliman
Active Member
- Joined
- Jul 7, 2002
- Messages
- 255
Hello everyone.
In a sheet named MasterSheet I have a list with two dependant columns.
Col E: Business unit
Col C: Employee
There are 3 BU. In a separate worksheet I have the employees of BU1 listed in col A, the employees of BU2 in col B and the employees of BU3 in col C.
My goal is to write a macro that checks the employee names entered in col E of the MasterSheet based on the Business Units of col C. I thought that this macro could run before saving the workbook and don´t allow to save the file if there are bad entries.
Thank you very much
In a sheet named MasterSheet I have a list with two dependant columns.
Col E: Business unit
Col C: Employee
There are 3 BU. In a separate worksheet I have the employees of BU1 listed in col A, the employees of BU2 in col B and the employees of BU3 in col C.
My goal is to write a macro that checks the employee names entered in col E of the MasterSheet based on the Business Units of col C. I thought that this macro could run before saving the workbook and don´t allow to save the file if there are bad entries.
Thank you very much
