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
