Please find below link for how to creat pivot table on multiple sheet...
http://www.youtube.com/watch?v=ZBn1-r0I5oE
On Sat, Mar 10, 2012 at 10:40 AM, Mohammed Muneer mmun...@ccc.com.qawrote:
Dear Group Plz, tell me how I can use it? And for what purpose?
** **
** **
Regards,
It's a pre posted solution
Ok..
Its an add-ins which can take input from multiple worksheets within a
workbook .. when you will press shift+ctrl+P a dialogue box will open to
take input ranges you can add multiple range (All range should have same
format and no column should have blank
: RE: $$Excel-Macros$$ Pivot multisheet how to use? for what
purpose?
It's a pre posted solution
Ok..
Its an add-ins which can take input from multiple worksheets within a
workbook .. when you will press shift+ctrl+P a dialogue box will open to
take input ranges you can add multiple
Hi Muneer,
See the attachment where I have created a mutisheet pivot.
Use:- For example, if you have the scores of a team against different
matches and you wanted to sum the scores, you can use a multisheet pivot in
this case, see the attachment and look in sheet pivot which have the data
from
Dear Ashish,
Click on below link to learn about Multi Sheet Pivot.
http://office.microsoft.com/en-us/excel-help/consolidate-multiple-worksheets-into-one-pivottable-report-HA010226585.aspx
Thanks
Ahmed Bawazir
On Sat, Mar 10, 2012 at 3:09 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote: