pivot table clear data in cells

[Visual Basic]

have pivot table set up in report format with various fields from a CRM database. I want to clear blank data in the cells when the user click in the pivot table cell to open a certain cell to view the data that is whtiin the pivot table. it creates a new sheet with all the data in but i only...