Multiple tables automatically updated

Take this:

1. Create a Dropdown for Service Selection

• Go to a cell (e.g., D1) and use Data Validation:
• Data → Data Validation → Allow: List → Source: A,B

2. Use FILTER or INDEX/MATCH to Populate Tables

Assuming your full data is in a table named DataTable with columns: Department, Section, Service, Expenses.

You can use the FILTER function (Excel 365 or Excel 2021):

=FILTER(DataTable, DataTable[Service]=D1)

This will return all rows where Service matches the selected value.

To break it down by Section (1, 2, 3), use:

=FILTER(DataTable, (DataTable[Service]=D1)*(DataTable[Section]=1))

Repeat for Section 2 and Section 3 by changing the Section value.

3. Display in Separate Tables

Place each formula in the starting cell of your Section 1, 2, and 3 tables. Excel will spill the results automatically.