Hi,

Would it be possible to have a vlookup function next to the pivot table and when hitting the option “Show report filter pages” the vlookup would proceed with each tab. Would macro work with what I’m trying to achieve? I have about 80 filter pages (tabs), so it’s not possible to go into each tab and do the vlookup.
Is there anything else what I could do? Thank you for your kind replies.