Hi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated.
I have some good formulas already set on 2 separate sheets that calculate the amount of people toward the manager ID and subtract in another column by total of unexcused from the master sheet to give a valid amount of people on site.
However I would like it a little more detailed
in the 2 non master sheets i have a few sections where I would like for the person to auto populate based on criteria of their manager and unexcused "X" in the column in the master sheet with all of the data in that row in the master sheet going under each managers section.
Ive been working on macros and different formulas but nothing seems to work.
I have a huge headache and would appreciate any help given.
I have some good formulas already set on 2 separate sheets that calculate the amount of people toward the manager ID and subtract in another column by total of unexcused from the master sheet to give a valid amount of people on site.
However I would like it a little more detailed
in the 2 non master sheets i have a few sections where I would like for the person to auto populate based on criteria of their manager and unexcused "X" in the column in the master sheet with all of the data in that row in the master sheet going under each managers section.
Ive been working on macros and different formulas but nothing seems to work.
I have a huge headache and would appreciate any help given.
