I work in a manufacturing company. I am trying to create an automated manning roster of each of the 3 shifts with a reports tab of each shift and then a report of all shifts combined (by automated I mean whatever is updated or changed in the roster will update the charts as well). We are wanting to be able to visually see only the "Inactive" (OPEN, FMLA and OUT) by Supervisor, by position, by how many are each by supervisor ect. I have spent many hours and can not get it. I tried the advanced filter function but I keep getting an error: extract range has a missing or invalid field name. Unless someone has a different idea of how to get only the columns to the chart sheet to create the charts I am stumped.
Bookmarks