I think I might be approaching the length of my ability. I have been creating a workbook to track the readiness of our employees to travel to other locations. Each employee has to accomplish about 30-40 items to complete thier pre-travel requirements.
Attached is an example of what I am talking about. Our actual spreadsheet has about 80 names (about 3-20 are added or removed each week), and my superiors are asking me for a product which can, at minimum, be used to report to their superiors.
Sheet 1 is the full list of people and items in the table.
Sheet 2 is a blank table of what needs to be shown and an example of exactly what should automatically populate inside the table.
Thanks for checking it out.
Bookmarks