alishabbir
New Member
- Joined
- Dec 22, 2016
- Messages
- 4
I have 3 tabs: 1. Title Page, 2. Reference 3. Sales Data
The idea is on the the TITLE page, user will select Period 1 from the drop down --> This is linked to REFERENCE TAB via cell link functionality, so automatically on the REFERENCE tab cell N3 gets updated with Period 1..... I am good up until this point.
What I would like is on Tab 3 (SALES DATA tab), Pivot 5 filter "Fiscal Month" gets updated with Period 1.
I am very new to <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> and really appreciate your help. Thank you!
The idea is on the the TITLE page, user will select Period 1 from the drop down --> This is linked to REFERENCE TAB via cell link functionality, so automatically on the REFERENCE tab cell N3 gets updated with Period 1..... I am good up until this point.
What I would like is on Tab 3 (SALES DATA tab), Pivot 5 filter "Fiscal Month" gets updated with Period 1.
I am very new to <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> and really appreciate your help. Thank you!
