Pivot Table - Filter - Hyperlinks?

[Annie1904]

I have no idea how to describe this, because I don't know if I'm talking
about a pivot table, or filter, or something altogether different.

My colleague has been sent a spreadsheet, origin unknown so we can't ask
them, which details all of the sales made by the different teams over the
past twelve months. On the left, there is a drop down menu from which she
can choose the month, or indeed a total for the year, and along the top there
is another dropdown menu from which she can choose which team. she wants to
look at.

It does return information in the same way a pivot table would, but it's
formatted in quite a different way. And it's much easier to view than a
standard pivot table.

I wondered if anyone could recognise what I'm talking about, and indeed how
you can set this up?

 

[HKaplan]

Sounds like a pivot table that has been formatted. Right click in the
report and see if the pivot table short cut menu opens up. It will say
Wizard, Refresh Data, etc.

 

[Annie1904]

No - it doesn't have any of that, which is why I don't think it is a Pivot
table. If I have a wild guess, it's more like a hyperlink to a Vlookup
formula - does that make sense? I just can't see what's in the background to
make it work. A.

 

[HKaplan]

Then likely it uses VBA and form objects. Hit Alt F11 and double
click the sheet objects in the left pane to see if there is any VBA
code.

If you want, and the data is not private, you can send to me
(e-mail address removed) and I will evaluate it.