List Pivots in workbook & Sheet Location

Morning all,

a fresh new query for you all,

I have a workbook called disputes and it has 2 pivots in, each on seperate sheets.

What i would ideally like is a macro that gets the pivot table names and places them on a new sheet called "Info". Next to each pivot name i woul also like the sheet it is on.

I hope this is possible, if so please help.

Cheers for reading my thread

This might get you started. You need to search the Forum for code to add a new sheet, I have posted examples including a fiunction that will check if the sheet exists before adding it. If it exists then clear the existing data.

Please Login or Register  to view this content.

Thanks for the post roy, I have been tinkering with some code and managed to get it to work but this is a bit cleaner!!

cheers as ever!!