Help with monthly update/tracking

[Thrawn]

Hello everyone, I have a question that I was hoping the community could help me with. One of my roles in my job is to check and track which departments/teams update their schedule on time for both regular hours and on-call. My current process is going through a list in Excel and simply putting a y or n next to the department. Then, I sort them and copy and paste them into the monthly record. I have been playing around with formulas, trying to find a way to help, but no luck. Ideally, I would like to figure out a formula to put on the monthly tabs that pull the departments with n next to them at the end of the month. The closest I came to this is having the month triggering, but on my test page, everything returns false when the next month happens. I looked around and couldn't find anything formula-wise, so I'm sure this would probably be a macro or something. However, I have never used a macro in Excel and don't know where to start. Any help would be welcome.

 

[awoohaw]

Welcome to the forum. Can you tell the forum which version of excel you use (please update this into your profile so it appears in your chat button... see how mine says office 365?).

Secondly, can you post some sample data (preferably with the xl2bb add in - link below). If you can't use the add in the copy and paste data as a table. While images are helpful it means the forum must recreate the scenario which can be error prone and is time consuming. You'll get a faster response if you help the forum help you.

Including an expected result would be helpful as well. Additionally, if you can't use the xl2bb please label the columns and rows, and provide any formulas you may have.

Thanks in advance.