• 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

    Hui...

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

Dynamic Table fed by GetPivotTable

kdibai

New Member
Hi guys, I'm struggling with this for a long time, no can do more :(

It really seems that I need to do by hand the same solution that a pivot table give us.


I need to create a dynamic table or range of cells that are able to add or remove rows correspondly to how many datas are in the store selected in the pivot table. Plus, we have fixed categories that group these datas.


I can't use the pivot table itself cause I need to do a better presentation of the datas.


eg:


Store selected: A

+Fruits

+Computer


openning that, we need to have a dynamic range after each category (if the user select store B, the products in fruits and computer category would change, B could have 5 fruits and 15 computer products per example).


Store selected: A

-Fruits

Apple

Banana

Pineapple

-Computer

Mouse

Keyboard

Monitor

Printer


notes:

* I'm using getpivottable cause my data is huge and can't use sumproduct and similars cause really slow down everything.

* Excel 2007 only


Many thanks in advance for all the help.
 
Back
Top