The add in is awesome, but I can't see all the details because its showing black on my PC too...It would be very nice and kind if you could post an updated version.... Thanks
On Aug 9, 3:01 am, "Rajan_Verma" <rajanverma1...@gmail.com> wrote: > Hi Anil, > > Later I will provide you a updated Code , I had created that code About Two > Year ago.. I have to work on this Again, So will get it soon > > Regards > > Rajan. > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Anil Bhange > Sent: Tuesday, August 09, 2011 12:01 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Multiple Range Pivot Table > > Hi Rajan, > > Thanks for your macros and kind help, but unfortunately this will not work > for me as I want to update this Pivot table every time in change in data, > whereas this macro create separate database for pivot table creation. I > thought of other way, can we able to add multiple range in below screenshot, > > So that we can create the Pivot table with multiple range with different set > of columns > > Regards, Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Rajan_Verma > Sent: Monday, August 08, 2011 04:48 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Multiple Range Pivot Table > > Sorry For that.. I have attached Another One File. > > Add this addins and Press Ctrl+Shift+P > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Anil Bhange > Sent: Monday, August 08, 2011 12:20 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Multiple Range Pivot Table > > Ctrl + Shift + P is not working in attached file > > Regards, Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Rajan_Verma > Sent: Sunday, August 07, 2011 07:00 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Multiple Range Pivot Table > > Add this add in and Press Shift+Ctrl + P and Follow the step > > Hope it will helps > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Anil Bhange > Sent: Sunday, August 07, 2011 5:24 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Multiple Range Pivot Table > > Hi All, > > Is there any way where I could able to create Pivot table with multiple > ranges and able to use all the columns of all ranges as like normal Pivot > Table. > > I know the Multiple Range Consolidation but in this you can only play around > with Row, Column & Data and not with all column heading. > > Please let me know if any facility available in excel. > > Anil Bhange > > Business Planning & Management Reporting > Financial Planning & Analysis, > > TATA Communications Ltd. > 6th Floor, B Wing, > Bandra Kurla Complex, Bandra (East), > India > > ' Desk : + 91 22 6659 2320 > | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 > > <mailto:anil.bha...@tatacommunications.com> > anil.bha...@tatacommunications.com > > -- > --------------------------------------------------------------------------- - > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > -- > --------------------------------------------------------------------------- - > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > -- > --------------------------------------------------------------------------- - > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > -- > --------------------------------------------------------------------------- - > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > -- > --------------------------------------------------------------------------- - > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/discussexcel > > image001.png > 233KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
