I'm a school administrator tracking attendance across multiple campuses. Each campus is on one worksheet. I have drop down lists indicating if someone is present, or the type of absence, and it's separated by date.
What I would like is: compile all the instances in the workbook that someone was ill or on vacation, and then on a separate worksheet, list all the corresponding student's name and campus location for that day.
Info you may need: Worksheet Name is the same as the Header, there are about 12 sheets, I'm a new excel user, so please keep that in mind when you're explaining what is probably a very simple formula :)
If anyone can provide me with a generic formula that you can dumb down for me, I can probably plug in the right info.