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
Bookmarks