Search results

I in no way expected anyone to do this work for me, just point me in the right direction. So, you have done already much more than you needed to. If VBA is what I need to do, then I will look at what is involved. I don't need to extract the exact value, just check for "no" values and report back...

Thanks for the reply. I guess I needed a bit more detail. I have separate columns and I can get the formatting sheet to sheet consistent if needed.

I need to look up a simple "Yes" value on multiple sheets for an attendance and homework tracker I am building for a work project. I need to pull out only the present students, list them and then indicate per day if they have reported homework or not. Each day's attendance is on an individual...