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.
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.