Friday, May 24, 2013   
  Search   
 

Office 2010 - Launch Event

Register  Login  
Forums  
     Minimize  

MeraWindows Forums - Get your Computer Problems Fixed

This is a site run by the community - for the community. At the site, we share and contribute our computer learnings with each other. We discuss about Windows, Office, Mobile, Gaming and other computer related topics. At our forums you can post your queries and our very helpful community members will respond quickly to your queries. We organize lots of competitions from time to time and award prizes to the winners.
You will need to register at the site before posting in forums. It's absolutely free. After registering, you can get all the benefits available to our registered members, you can access our Downloads section, you can participate in contests, etc. You can post in forums in English as well as in Hindi, in fact we encourage you to use Hindi in your posts. If you have any problem with registration or login, please contact us.

     
  
HomeHomeMicrosoft Offic...Microsoft Offic...Microsoft ExcelMicrosoft ExcelMACRO TO CREATE PIVOT OF MULTIPLE SHEETSMACRO TO CREATE PIVOT OF MULTIPLE SHEETS
Previous
 
Next
New Post
5/31/2011 4:47 PM
 
Hi All,

I have a file in which I have to create a pivot table , I found a macro for the same through google, but now I need assistance
to apply it on my Data, their is an error message showing in it when I am running MACRO Create Sample Table.
Can any body assist me for the same.

Bregds,
Rajender.
 
 Pivot Consolidation Macro.xls
New Post
5/31/2011 9:39 PM
 
Hi,

Instead of identifying the problem in the code, will yo be OK if i can write a code for you to consolidate the data from multiple sheets into one sheet.  Once the data comes on one sheet, you can then create a pivot table.

Do let me know if this would suit you?

For Microsoft Excel trainings in India, please visit http://www.ashishmathur.com/corporate-interventions/

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
Website
Blog
 
New Post
6/1/2011 10:05 AM
 
Hi Ashish,

That is also ok for me. I will link that range to Pivot table separately.

Thanks ,
Rajender

 
New Post
6/5/2011 7:41 PM
 
Hi,

Give this macro a try.  It consolidates data from all sheets.  Instructions on the file itself.

The macro can be made for more concise but should be good enough to get you started off.

Do let me know how this works

For Microsoft Excel trainings in India, please visit http://www.ashishmathur.com/corporate-interventions/

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
Website
Blog
 
 Consolidate.xls
New Post
6/7/2011 2:10 PM
 
Hi Ashish,

Thanks a lot. I tried it to another reports too for consolidation and its work amazingly. it really saving lots of time.
 
Bregds,
Rajender
 
New Post
6/7/2011 4:05 PM
 
Hi,

You are welcome.  Glad my solution worked

For Microsoft Excel trainings in India, please visit http://www.ashishmathur.com/corporate-interventions/

Regards,

Ashish Mathur - View Ashish Mathur's profile on LinkedIn
Microsoft Excel MVP
Website
Blog
 
Previous
 
Next
HomeHomeMicrosoft Offic...Microsoft Offic...Microsoft ExcelMicrosoft ExcelMACRO TO CREATE PIVOT OF MULTIPLE SHEETSMACRO TO CREATE PIVOT OF MULTIPLE SHEETS


   User Log In Minimize  


Register
Forgot Password ?

     
  
   Follow Us Minimize  
     
  
     Minimize