Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2012, 02:54 AM
ejima ejima is offline Help with pivot table macro Windows XP Help with pivot table macro Office 2007
Novice
Help with pivot table macro
 
Join Date: Feb 2012
Posts: 1
ejima is on a distinguished road
Default Help with pivot table macro

Hello All,
I created a pivot table from the data on sheet titled RawData however, there are some modifications i will like made on the pivot table:
Please find attached the sample data for further clarifications.
1) The sheet titled rawdata contains the data from which pivot chart is created.
2) The sheet titled "Pivot Chart gotten from macro" is the pivot chart gotten after the macro runs.


3) the sheet titled "expected outcome" is the pivot chart done without using a macro, this is the outline which we want to get when we run the macro for the pivot chart.

I need assistance with modifying the macro foso that i can get the pivot chart displayed in the format represented in the sheet "expected outcome" and also ensuring user input is requested for the pivot table's sheet i.e the sheet is named after whatever user input is fed before the pivot table is created.

The macro is attached in text format and the excel document is in the zipped folder.
Thank you.
Attached Files
File Type: zip sample data.zip (25.1 KB, 17 views)
File Type: txt sample.txt (936 Bytes, 11 views)
Reply With Quote
  #2  
Old 02-15-2012, 02:38 PM
Capungo Capungo is offline Help with pivot table macro Windows 7 64bit Help with pivot table macro Office 2003
Novice
 
Join Date: Feb 2012
Posts: 6
Capungo is on a distinguished road
Default

Have you ever thought that you can build the pivot table in this very design permanently and keep it hidden and refresh it by a macro according to the new rawdata and make it visible again? This way you wouldn't have to make up a new pivot table by macro everytime an input happens.

If it's ok for you, it's very easy to direct users to give a name to the sheet by the inputbox function.
Reply With Quote
  #3  
Old 02-16-2012, 03:45 PM
zyzzyva57 zyzzyva57 is offline Help with pivot table macro Windows 7 32bit Help with pivot table macro Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

Does this help?


Attached Files
File Type: xlsm My-sample data.xlsm (41.0 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA: Recording a macro to insert a PIVOT table e093223 Excel Programming 0 10-09-2011 01:55 AM
Help with pivot table macro Pivot Table Karen615 Excel 5 08-03-2011 10:46 AM
pivot table design 2 dmonroe Excel 2 11-15-2010 09:15 AM
Pivot Table Refresh tpcervelo Excel 0 09-14-2010 06:54 AM
Help with pivot table macro Pivot Table's fields janis129 Excel 7 03-02-2010 03:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft