Can someone please confirm whether or not it would be possible to create a macro that would look at the filtered range in a pivot table dropdown filter and then list in a cell for example "2012 to 2023". I have attached a picture to give an idea of what I mean. Generally with a pivot table filter, once you select more than 1 item it just shows "Multiple Items" whereas I would like to display the lowest and the highest years as a heading.
I have tried using a formula but I can't work it out.
Can anyone please help?