How to Mirror Changes from One Sheet to Another in WPS Spreadsheets and Excel
Question details
The user needs to keep a secondary worksheet updated automatically when rows are added or changed in a master worksheet, especially when creating team-specific views from shared data.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A team uses a master worksheet for raw event or record data and wants separate team views or reports that reflect newly added rows without manual copy-paste.
- Observed behavior
- Manually synchronized secondary sheets may not update when rows are added, edited, or removed from the source data.
Before building the link, make sure the source data is in a single clean table with one header row, no blank rows, and a dedicated column for the team or category you want to filter by.
Create a self-updating team view with the FILTER function
Use this solution when you want a secondary sheet to automatically include new rows and changes based on a selected team or category.
The FILTER function returns a dynamic array from the source range. As long as the source data is a clean table and the formula references the full table or full column range, the output grows automatically when new records are added.
Open your workbook in WPS Spreadsheets or Microsoft Excel and confirm that the master sheet has one header row with fields such as Team, Date, Event, and Owner.
Click the secondary sheet tab where the team-specific view should appear, then select the first empty output cell.
Type =FILTER(MasterTable,MasterTable[Team]="Alpha","No matching rows") and replace MasterTable with your source range or Excel Table name and Team with your filter column.
Press Enter and allow the dynamic array to spill. Apply the desired number format, column widths, and table styling to the spill range.
Add a new row to the master sheet and confirm that the FILTER output immediately includes it when the row meets the filter condition.
Restructure the source data before filtering
Use this solution when the current master sheet contains blank rows, merged cells, or dates stored as row labels, because those prevent formulas from updating reliably.
Mirror Sheet Changes Automatically in WPS Spreadsheets
In WPS Spreadsheets, use the FILTER function and a clean source table to create a team-specific view that updates automatically when new rows are added or edited, without manually copying data.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, click Spreadsheets, and open the .xlsx file that contains the master worksheet.
- 2. Format the source as a clean table: On the master sheet, select the data, click Insert > Table, confirm the range, and enable My table has headers.
- 3. Create a filtered team view: Click the secondary sheet tab, select an empty cell, and enter =FILTER(Table1,Table1[Team]="Alpha","No records").
- 4. Save and share the workbook: Press Ctrl+S to save the file, then use Menu > Share or export to .xlsx so teammates can see the auto-updating view.
Frequently Asked Questions
Does the FILTER function update automatically when new rows are added in WPS Spreadsheets?
Yes. If the formula references an Excel Table or a full column range, WPS Spreadsheets returns a dynamic array and the output expands automatically whenever a matching row is added or changed in the source data.
Why does my secondary sheet not include new rows from the master sheet?
Usually the source range has blank rows, the formula references only a fixed range, or the data is not in a single table with one header row. Remove blank rows, use an Excel Table, and reference the whole table in FILTER.
Can I mirror data from one sheet to another in Google Sheets using the same approach?
Yes. Google Sheets supports =FILTER(range, condition) and dynamic array behavior, so the same clean-table structure and FILTER formula work in Google Sheets and Excel.
How do I show only one team at a time in a secondary worksheet?
Put the selected team in a dropdown cell, such as Data > Data Validation, and change the FILTER condition to reference that cell: =FILTER(Table1,Table1[Team]=$B$1,"No records").
