I have a pivot table that varies each month and I would like to add in a kind of of VB botton that would permit to create a temp
worksheet with derived data from table. ( The button will permit to explode the data on a specific line of pivot table).
Just want to know how to add a button in pivot table and I will add in the vb code afterwards for the temp worksheet.
thanks to all.
worksheet with derived data from table. ( The button will permit to explode the data on a specific line of pivot table).
Just want to know how to add a button in pivot table and I will add in the vb code afterwards for the temp worksheet.
thanks to all.