Not sure how "extraordinary" you want to go <g, but think it'll be worth
trying Debra's pages on Pivot Tables as a start. Browse the many links under
"P" at her index page:
http://www.contextures.com/tiptech.html
(also, look at GetPivotData under "G-M")

... btw, please do not post in all caps. It's tough to read, and may be
considered impolite by many ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Sanjeev" wrote in message
...
SHOULD ANY ONE KNOW SOME ADVANCE STAGE OF PIVOT TABLE.

I KNOW ALL BASIC OF PIVOT , BUT IN SEARCH OF SOME THING EXTRAORDINERY.


THANKS IN ADVANCE

SANJEEV