Forum Discussion
Excel List Based On Multiple Criteria
There are probably several different ways your goal could be met. Some simple, some at varying degrees of sophistication. I'm not a Power Query user yet, and unless I'm mistaken, using it would require a redesign of the layout of your sheets. Same redesign would be needed for the various older D_____ functions, with which I am familiar, as ways to extract data from data tables. But if all you're looking for are total vacation days (see the question below), then there are some simpler ways to do it.
However, it's not clear enough yet, from your question and a review of the sample sheets, how the underlying sheets are to be used. You call this an "Attendance" workbook, yet are asking about creating a report on Vacation time. I understand they're related, but it's not clear whether the individual sheets are recording both attendance AND vacation (AND, perhaps, sick leave, etc).... or ONLY Vacation days.
You ask for "a list [that] will return with all of the dates that have December in them from all of the other sheets" -- notice the added highlight: do you actually want DATES, or just the COUNT of days that are coded for vacation (however that happens). It's an important distinction.
In any event, thank you for uploading the sample sheets. I do hope that those are not the real names of people. It's generally the practice on these boards to remove identifiable names, etc., before uploading sample files. But thank you for the sample.
But in order for me (or others who have knowledge of Power Query, which I don't) to be of further assistance, we'd really need to know the answers to the following questions, at a minimum:
- How are you (or others?) filling in the boxes on the individual data sheets? With numbers? Integers only or are decimal fractions allowed?
- Are you entering ONLY vacation days taken?
- What is your role in this? (I'm kind of assuming you're in charge of HR or part of HR)
- Who else (if anyone) will be using the sheets? How?