delete blank data from a pivot related workbook
 

i have pivot table in a excel sheet and it pulls data from a CRM database. when a user clicks any data in the pivot table it creates a new worksheet showing all the data that is related to that data selected. I want to know is how can i delete the epmty cells in this new work sheet can i...