Assigning VBA code to slicer?

[cyrous0425]

Sorry if the title is incorrect. IDK the correct term for it. My problem is I have two sheets "CREW 1" and "CREW 2". CREW 2 is the duplicate sheet of CREW 1. After I make a duplicate sheet (CREW 2) the slicer and columns doesn't work anymore. I want it to work same as CREW 1. Is is possible? Here's a link of my sheet. Meet Google Drive – One place for all your files .Thank you.

 

[starl]

How is VBA involved in this?
Creating a copy of the sheet should affect the slicer. More details are needed - slicer to a pivot table or a table (list object)?
When you say the duplicate isn't working, what exactly do you mean? Clicking the slicer does nothing nor do the column drop-downs? Can you interact with the cells otherwise (if a table, can you change the values?)