• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot effect on a normal formula based table ! Is this possible ?


New Member
Hello Experts -

I am creating a table mostly based on formulas to lookup raw data to arrive at some results. This table is much customized which I could not arrive out of a pivot table

For example:

I have multiple levels and sublevels to show them orderly for which I need to create multiple pivots and place them at right position.

Is it possible to have my table just based on formulas but when clicked on a data within the table show me the actual data behind it. the same effect that pivot table does?


Excel Ninja
It's possible to do via VBA.

Code and how you go about doing it will all depend on your workbook structure etc.

However, be warned, this isn't often something that's simple or easy to implement.