• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Refreshing Macro

A

Aswinraj

Member
Hi bro..,

I need a help to create a Macro for refreshing the Pivot.., I have provided the details below,.. Kindly help me on this..,
In Home Page
1.In Dropdown - It should contains Months name in the Drop down.
When user choose any Month and Click Create Sheets - It should copy all the previous 10 sheets including datas (Sheets of Previous Months alone) and the Sheet names should be replaced with the Current Month name. Example: EPO - 1 (May 2016) to EPO - 1 (June 2016)

[User will paste the Raw data in Sheet "EPO Compliance" ]

2.Refresh Pivot Button - When user clicks the Button, it should fetch the data source from the latest Month sheet "EPO Compliance" and it should refresh all the Sheets.
Ie., It should refresh all the data based on the Month which has been selected in dropdown, in the beginning.
Example: When User Choose May, then it should refresh the data source for the Sheets May.

3. Condition for Refreshing Pivot - For Sheets 1 - 8, it should fetch the data source based on COlumn M and Column N (Col M - Active and Col N - False).

ie., it should fetch the data till last column which Contains Active in Column M and False in Column N and all 9999 data should not be considered.

But for Sheet 9 - It should fetch the data source of whole EPO Compliance Sheet.

Can you please help me on this.., I have to submit it before next Wednesday.., Please please help me..,
 

Attachments

  • Pivot Refreshing Macro.xlsx
    679.7 KB · Views: 3
vletm Can you help me on this???? Please help as much as you can.. Even few Macro steps also enough for me.. Like Bringing Months in Dropdown and Copying last Month 10 sheets into new Sheets and renaming with the Chosen Month name when GO button is clicked.., Something is better than nothing :)
 

Attachments

  • Pivot Refreshing Macro.xlsm
    694.3 KB · Views: 1
Last edited:
In shot.., These are the steps needed in Macro..,

Step 1: In Home page - A dropdown should contains Months name
Step 2: Go Button - When user clicks this button, it should copy all previous Month sheets (Totally 10 sheets [From Sheet EPO 1 to EPO Compliance]) and rename with Month name which user choose.

Step 3: Refresh Button - User will update the data in Sheet EPO Compliance Sheet, and then clicks this button. Once it was clicked it should refresh all the pivot data from 1 to 9 sheets.

Condition for Refreshing Pivot - For Sheets 1 - 8, it should fetch the data source based on COlumn M and Column N (Col M - Active and Col N - False).

ie., it should fetch the data till last column which Contains Active in Column M and False in Column N and all 9999 data should not be considered.

But for Sheet 9 - It should fetch the data source of whole EPO Compliance Sheet.
 
You must log in or register to reply here.
Back
Top