Help With Macros Tied To Buttons

Good afternoon, Gurus!

I apologize that this query is going to be as vague as it will be, but I'm at a loss for better words.

I've attached a workbook (stripped of sensitive info) that has macros assigned buttons on two of its tabs: "Perfect Attendance Summary" and "Print Out." I've been tasked with generally fixing this workbook as after many years a misuse, a lot got messed with. I'm able to fix the Excel formulas for the most part, but a large part of it's primary function is the two tabs I've mentioned, but they use macros, and you could fill an ocean with all I DON'T know about VBA. I was wondering if someone might be able to take a look at them, and help me figure out what exactly they're "supposed" to do, why they're not working now, and, mostly importantly, hopefully assist in fixing them.

Thank you in advance for any help anyone is able to provide.

Thank you!

Originally Posted by 6StringJazzer

If you don't know what they're supposed to do, how do you know they are not working? We need a little more to go on. If you don't know where you are going, you will definitely get there.

According to the end users, they're "not working," and as I'd never seen or used it before, yet I was referred to them as someone who could help. Sadly, none of them can articulate what exactly is "broken." I found a few formulas I was able to clean up, but the macros have been a hard stop for my expertise.

Originally Posted by jolivanes

Besides that the people in your example are going to be busy this weekend in Bahrain, its like Jeff said.
The code seems to be from the macro recorder, a tremendous amount of selecting, so it would need to be cleaned up anyway.
Find somebody that used it before it quit working and ask him/her what it should do and start over.

Lol, yes, they'll all be busy in Bahrain, and I can't wait! I used their names as "dummy" inputs for the purposes of posting the workbook here, but nice catch!

And I wish I could find someone who's used it before it quit working, but what started out as a uniform template across multiple facilities got modded and manipulated into multiple versions, so we've got a tower of Babel situation where no one is speaking the same language. And of course, the priginal author is no longer with the company.

Originally Posted by bebo021999

It is better for you (also for helpers here) is:
- Start again from zero
- Point out what data is raw data, and what data is expected outcome (from formula, VBA code,...): Before and After

Your first bullet is exactly what we're trying to avoid, and as to your second, it depends on who you ask as you can see in my response to jolivanes above. The intent for my fixing it was to get everyone on the same page again, but in some cases, it seems they're not even reading the same book...

Originally Posted by 6StringJazzer

I am dying to know if this helped.

I am SO sorry; I have email notifications set up to let me know when someone responds to this thread, but I swear I didn't see one for your reply! I got the notification for your most recent reply, though, and I see you offered your help 3 WEEKS ago. Thank you so much, I will send your version over to the end users to see if it is working now.

Again, I'm truly sorry I didn't see your help from 3-2-2023 until just now!

Originally Posted by 6StringJazzer

I am dying to know if this helped.

Hello, 6StringJazzer!

I finally got some feedback from the end users on your suggested fix, and unfortunately, according to them, it's still not doing what they need it to do. I've tasked them with painstakingly detailing EXACTLY what they want from these pages, so maybe I can try and recreate something similar and less clumsy in the revised version of the attendance tracker I (with the help of several Gurus here) made for them. For now, I'm just going to mark this thread "solved" and will re-open a new one once I have more concrete feedback to try these tabs again.

Thanks again for your efforts, and again, my deepest apologies for not seeing your response sooner.