Resize Table - Excluding Blanks After Pivot Change

Hi All

Would someone please help with some code.

I have a pivot table called "DataPivot" and a table called "Report"

I am looking for code that will refresh the filter on my table (Heading called "No") to excluded blanks when the pivot table changes (after slicer selection).

Many Thanks



Diane

Sorry for not attaching file in first instance.....I was having trouble with the upload.