Help with monthly update/tracking

Thrawn

New Member
Joined
May 8, 2019
Messages
1
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.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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.
 
Upvote 0

Forum statistics

Threads
1,224,814
Messages
6,181,126
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top