Hello all,
I am having an issue with pulling information from drop down menus and different worksheets and getting that information to populate in a master worksheet.
Essentially, i have these worksheets: Calendar View (Master Worksheet), Employee Audit Tracker, List of Employees, Audit Types
My staff undergo a bunch of audits and certifications over their tenure at my company. The employee audit tracker allows me to have dropdown menus with the employee, then a date, type of aduit and then metric scores. The master worksheet pulls all of this information into a cohesive page when i can click on a drop down menu and pick an employee. The problem is, i can't get each employee to populate the proper information. I attached the workbook mentioned above. any help is greatly appreciated
UPDATE:
I got the information to pull properly, but now i am struggling with getting the type of audit drop down menu to link with the individualized data for each employee. Again, help is greatly appreciated
Audit Workbook.xlsx
Bookmarks