Maries,
Thanks
regards,
Pawel
________________________________
From: Maries <talk2mar...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Sunday, February 12, 2012 12:58 PM
Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
Hi Pawal,
Instead of using Combo box & Index formula, I have used Daa validation in B4.
Also I have used the following code to update the data input to pivot filter
when worksheet change condition.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address(False, False) = "B4" Then
ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").CurrentPage =
Range("B4").Value
ActiveSheet.PivotTables("PivotTable3").PivotFields("Date").CurrentPage =
Range("B4").Value
End If
End Sub
Thats it.
Regards,
MARIES.
On Sun, Feb 12, 2012 at 3:50 PM, pawel lupinski <lupins...@yahoo.com> wrote:
HI MARIES,
>
>
>Can you let me know how you've done this, please
>
>
>Regards,
>
>
>Pawel
>
>
>
>________________________________
> From: Maries <talk2mar...@gmail.com>
>To: excel-macros@googlegroups.com
>Sent: Sunday, February 12, 2012 5:33 AM
>Subject: Re: $$Excel-Macros$$ Synchronizing two Pivot tables.
>
>
>
>Hi,
>
>Find the attached file. I have done without INDEX.
>
>Regards,
>
>MARIES.
>
>
>On Sun, Feb 12, 2012 at 7:00 AM, Lawali <malaw...@gmail.com> wrote:
>
>Mahesh,
>>I have resolved the problem. I've used INDEX and Macro Recorder. See attached
>>file. But any better solution is welcome..
>>Thanks.
>>
>>
>>--
>>
>>"Imagine life as a game in which you are juggling some five balls in the air.
>>You name them - Work, Family, Health, Friends and Spirit and you're keeping
>>all of these in the Air. You will soon understand that work is a rubber ball.
>>If you drop it, it will bounce back. But the other four Balls - Family,
>>Health, Friends and Spirit - are made of glass. If you drop one of these;
>>they will be irrevocably scuffed, marked, nicked, damaged or even shattered.
>>They will never be the same. You must understand that and strive for it." 30
>>second Speech by Bryan Dyson (CEO of Coca Cola)
>>
>>
>>
>>--
>>FORUM RULES (986+ members already BANNED for violation)
>>
>>1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not
>>get quick attention or may not be answered.
>>
>>2) Don't post a question in the thread of another member.
>>
>>3) Don't post questions regarding breaking or bypassing any security measure.
>>
>>4) Acknowledge the responses you receive, good or bad.
>>
>>5) Cross-promotion of, or links to, forums competitive to this forum in
>>signatures are prohibited.
>>
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum
>>owners and members are not responsible for any loss.
>>
>>------------------------------------------------------------------------------------------------------
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>--
>FORUM RULES (986+ members already BANNED for violation)
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
>quick attention or may not be answered.
>
>2) Don't post a question in the thread of another member.
>
>3) Don't post questions regarding breaking or bypassing any security measure.
>
>4) Acknowledge the responses you receive, good or bad.
>
>5) Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited.
>
>NOTE : Don't ever post personal or confidential data in a workbook. Forum
>owners and members are not responsible for any loss.
>
>------------------------------------------------------------------------------------------------------
>To post to this group, send email to excel-macros@googlegroups.com
>
>
>
>--
>FORUM RULES (986+ members already BANNED for violation)
>
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
>quick attention or may not be answered.
>
>2) Don't post a question in the thread of another member.
>
>3) Don't post questions regarding breaking or bypassing any security measure.
>
>4) Acknowledge the responses you receive, good or bad.
>
>5) Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited.
>
>NOTE : Don't ever post personal or confidential data in a workbook. Forum
>owners and members are not responsible for any loss.
>
>------------------------------------------------------------------------------------------------------
>To post to this group, send email to excel-macros@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
