Hello All,
I have 2 pivot tables that run off a date filter linked to the same data. is there a way to have both the filters update if i use a value from a single cell.
e.g.
cell A1 has a date and it alters both the date field filter cells.
Hello All,
I have 2 pivot tables that run off a date filter linked to the same data. is there a way to have both the filters update if i use a value from a single cell.
e.g.
cell A1 has a date and it alters both the date field filter cells.
Last edited by Squevil; 11-04-2011 at 10:51 AM.
I do like these forum's!
this isnt exactly what i had in mind but it does resolve the issue!
Only issue i now have is that my dates are in UK format dd/mm/yyyy and when the dates on the other tables update it changes them to US format mm/dd/yyyyyPlease Login or Register to view this content.
not sure what to do with that?
Last edited by Squevil; 11-04-2011 at 10:53 AM. Reason: Solved- ish
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks