Sumproduct show pivot data

[vasim]

http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/


In the attached link - part

Scenario 2: Sum all values within a 2D Range matching 2 criteria


is there by any mean as we double click (sold) and get the 3-May data in a different sheet as we get in a pivot.


If possible, please can some code be shared.

 

[Hui]

Indian

To do what you want I would setup an Advanced Filter

That will achieve what you want


Have a look at:

http://chandoo.org/wp/2011/10/10/how-to-use-advanced-filters/

or

http://www.contextures.com/xladvfilter01.html


to get you started

 

[vasim]

Thanks just a few seconds are the post this idea came to my mind......still working on it..............thanks again