Automatically Display Maintenance Logs on Property Sheets in Excel
Question details
Create one maintenance log and automatically display each property's records on a separate worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Maintenance managers enter records on a central summary sheet, while each property sheet shows its matching entries.
- Observed behavior
- Each property sheet should update as matching records are added to the central log.
Make sure the central log has a header row and a Property column with consistent property names. Check that your Excel version supports the FILTER function, and leave enough empty cells on each property sheet for the results.
Use an Excel Table and FILTER to display each property's records
Use this approach in an Excel version that supports dynamic arrays to show new matching log entries automatically.
On the summary sheet, select the log data and headers, then choose Insert > Table. Confirm that My table has headers is selected.
Select a cell in the table, open Table Design, and enter MaintenanceLog in the Table Name box. Ensure the property column header is exactly Property.
On a property worksheet, enter the matching property name in cell B1. Use the same spelling as in the central log.
In an empty cell such as A4, enter =FILTER(MaintenanceLog,MaintenanceLog[Property]=B1,"No records found"). Leave the cells below and to the right empty so the results can spill.
Add the formula and a property name to each property worksheet. Then add a row to the MaintenanceLog table and check that it appears on the matching sheet.

Use Power Query when FILTER is unavailable
Use Power Query to load a filtered copy of the central log onto each property sheet, then refresh it when the source changes.
Display property maintenance logs in WPS Spreadsheets
In a WPS Spreadsheets version that supports FILTER, use a central log and a formula on each property sheet to display matching records.
- 1. Set up the log: Open WPS Spreadsheets and create a worksheet named Log. Enter your headers in A1:D1, with Property in column B, and add records below.
- 2. Enter a property name: Create a property worksheet and type the property's name in B1, matching the name used in the Log sheet.
- 3. Add the formula: In A4, enter =FILTER(Log!A2:D1000,Log!B2:B1000=B1,"No records found"). Leave the result area empty.
- 4. Repeat for other properties: Add the formula and the appropriate B1 value to each property sheet. Extend the referenced ranges if the log grows beyond row 1000.

Frequently Asked Questions
Will new maintenance entries appear automatically?
Yes. When you add a row to the MaintenanceLog Excel table, the FILTER formula includes it automatically if its Property value matches B1.
Why does the formula show no records for a property?
Check the property name in B1 against the Property column on the summary sheet. Differences in spelling or extra spaces can prevent a match.
What does a #SPILL! error mean?
The FILTER result needs empty cells to expand. Clear any existing content in the intended result area below and to the right of the formula.
What can I use if my Excel version does not support FILTER?
Use Data > From Table/Range to create filtered Power Query results for each property, then select Data > Refresh All after adding entries. Advanced Filter or VBA are other options.




