I have one sheet full of data (sheet titled DATA) of employees names and store numbers. I need to create a sheet for each unique store number, listing the employees names.
I have listed the store number at the top of the new sheet. For any matching store number in column A of DATA sheet, I need it to return the Employee Name in Column B of DATA sheet. And the employee names need to go on a new Sheet (STORE 1011)
My (incorrect) formula:
Setup a pivot table on a separate sheet and use the store number as a Page Report and Employee name as a Row value.
With the cursor in the pivot there will be an extra tab on the ribbon. At the left hand end of the ribbon there is a button for Pivot Options. Alongside it there is a dropdown and one of the options is to create page reports. Doing this will create a copy of the Pivot on separate tabs for each item in the Page Filters.