Function Problems

Automatically Link Category Sheets to a Master SKU Sheet in Excel

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 870 views

Question details

Automatically display SKUs from a master sheet on separate category worksheets.

Automatically Link Category Sheets to a Master SKU Sheet in Excel
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.
Before you start

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.

Solution 1Recommended

Use an Excel Table and FILTER on each category sheet

Use this approach to show matching SKUs automatically as the master table grows.

1
Create a master table

On the master sheet, select the SKU list and choose Insert > Table. Confirm that the table has headers, including a column named Category.

2
Name the table

Select a cell in the table, open the Table Design tab, and enter SKU_Table in the Table Name box.

3
Enter the category

On a category worksheet, type the exact category name in cell A1. Leave enough empty cells below for the results.

4
Add the FILTER formula

In cell A3, enter =FILTER(SKU_Table,SKU_Table[Category]=A1,"No matching SKUs"). The formula returns all table columns for rows matching A1.

5
Repeat and test

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.

Use an Excel Table and FILTER on each category sheet
Keep the spill area clear: FILTER returns multiple cells, so clear any existing content blocking the results. The table name and Category column name in the formula must match those in your workbook.
Work with SKU lists in WPS

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. 1. Open the workbook: Open your XLSX file in WPS Spreadsheets and identify the master worksheet and its Category column.
  2. 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. 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. 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. 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.
Display category-specific SKUs from a master worksheetUpdate formula results when data within the referenced range changesOpen and save Microsoft Excel XLSX filesWork in a familiar spreadsheet interface
microsoft office alternative - wps office

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.