Filter Function - Array argument referring to multiple Tables

[jmwbowen]

I'm creating an Employee Overtime tracker, using the web version of Excel 365, as the file is hosted in SharePoint and it's important that multiple users can access and edit the document at the same time.

There are separate tabs for each department, each tab has a table of identical structure, hosting the employee names, overtime dates, and overtime hours for each department.

I have a Summary tab that will provide summary data across all departments. This summary needs to list all entry rows from all department tabs between user-entered dates [start] and [end].

I want to use the [Filter] dynamic array function to pull info from each table on each tab, filtering for entries with dates between the [start] and [end].

How can the Array argument in the Filter function accept this?

Thanks!

 

[jasonb75]

Unfortunately, the filter function can only reference a single sheet.

If it was only for 2 or 3 fixed sheets then it might be possible to trick it into working by sequencing something along the lines of (untested theoretical method) CHOOSE({1,2,3},FILTER(Sheet1),FILTER(sheet2),FILTER(sheet3)) but for a large / variable number of sheets this would become impractical very quickly, and that is assuming that it can actually be made to work in the first place.