hi. Needs help. I have an attendance workbook with the 400 names listed as
present, absent or excused. Our office needs to see at a glance who are
absent for the day instead of looking at the data with 400 names. Is there a
way to have Excel automatically list those absent for particular in separate
worksheet or have those absent sorted in separate worksheet automatically. As
of now, we will copy and paste the names and their attendance everyday and
sort.