Automatically Link Category Sheets to a Master SKU Sheet in Excel
Question details
Automatically display SKUs from a master sheet on separate category worksheets.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook has a master SKU list and separate worksheets for individual categories.
- Observed behavior
- Each category worksheet should update when matching SKUs are added to the master list.
Check that the master list has a header row with a Category column and that your Excel version supports the FILTER function. Decide which cell on each category sheet will hold its category name.
Use an Excel Table and FILTER on each category sheet
Use this approach to show matching SKUs automatically as the master table grows.
On the master sheet, select the SKU list and choose Insert > Table. Confirm that the table has headers, including a column named Category.
Select a cell in the table, open the Table Design tab, and enter SKU_Table in the Table Name box.
On a category worksheet, type the exact category name in cell A1. Leave enough empty cells below for the results.
In cell A3, enter =FILTER(SKU_Table,SKU_Table[Category]=A1,"No matching SKUs"). The formula returns all table columns for rows matching A1.
Add the formula to each category sheet and enter its category name in A1. Add a new SKU directly below the master table and confirm it appears on the matching sheet.

Create linked category views in WPS Spreadsheets
In a WPS Spreadsheets version that supports FILTER and spilled results, use a formula on each category sheet to display matching rows from a master SKU list.
- 1. Open the workbook: Open your XLSX file in WPS Spreadsheets and identify the master worksheet and its Category column.
- 2. Check FILTER support: In an empty cell, enter =FILTER({1;2},{1;0}) and check that it returns 1. If FILTER is unavailable, check for a WPS update before proceeding.
- 3. Set the category: On a category sheet, enter the category name in A1 and leave the cells starting at A3 empty for the results.
- 4. Enter the formula: If the master sheet is named Master, its data is in columns A through C, and Category is in column B, enter =FILTER(Master!A2:C10000,(Master!B2:B10000=A1)*(Master!B2:B10000<>""),"No matching SKUs") in A3. Adjust the sheet name, columns, and row limit to fit your data.
- 5. Test the linked view: Add a matching SKU within the referenced master range and check the category sheet. Repeat the formula on other category sheets, changing A1 to each desired category.

Frequently Asked Questions
Will new SKUs appear automatically on the category sheets?
Yes. Add each SKU to the Excel Table on the master sheet, and the FILTER formula will include it when its Category value matches the category sheet's A1 cell.
Why does my FILTER formula show a spill error?
The formula needs empty cells for its results. Clear content in the output area starting at A3, and make sure the formula itself is outside an Excel Table.
How do I show a different category on another sheet?
Enter the desired category name in that sheet's A1 cell, then place the same FILTER formula in A3. The reference to A1 will use the value on that sheet.
What if my Excel version does not recognize FILTER?
Check whether your Excel version supports FILTER and update Excel if an eligible update is available. Older versions may require a different approach, such as manually filtering the master table.
Does the formula include the master table's headers?
No. The SKU_Table reference returns the table's data rows. To label the output, type matching column headers in row 2 above the formula.




