BarraPippo
New Member
Hello community
I have a Sheet, named "Shipment Table" that contains a table where i input details of my incoming shipments (ID, origin, destination, departure date, arrival etc)
This table populate a Pivot Table in another sheet, named "Shipment Report" which i would like to filter using slicers (by status, by arrival date (year and month)
I also create a VBA Macro that allows me to create new shipments from the "Shipment Report" sheet.
This macro will create an ad hoc sheet where i input all the details and then will populate the "Shipment Table" table and so on, the pivot table in the "shipment report" sheet.
Problem is: when i create the new shipment using the macro and update the tables, for some reasons, the slicers i created for the pivot table disappears.
This happens only if i don't input an arrival date on the shipment page.
I leave a test copy for whoever would like to budge in the discussion
What am i doing wrong?
I have a Sheet, named "Shipment Table" that contains a table where i input details of my incoming shipments (ID, origin, destination, departure date, arrival etc)
This table populate a Pivot Table in another sheet, named "Shipment Report" which i would like to filter using slicers (by status, by arrival date (year and month)
I also create a VBA Macro that allows me to create new shipments from the "Shipment Report" sheet.
This macro will create an ad hoc sheet where i input all the details and then will populate the "Shipment Table" table and so on, the pivot table in the "shipment report" sheet.
Problem is: when i create the new shipment using the macro and update the tables, for some reasons, the slicers i created for the pivot table disappears.
This happens only if i don't input an arrival date on the shipment page.
I leave a test copy for whoever would like to budge in the discussion
What am i doing wrong?