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!
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!