Slicer- link to two separate data sources

[salmonchild]

Afternoon Excelentrics

I have rather spiffing dashboard with multiple slicers controlling multiple pivot tables, so far so good. All pivot tables are based on the same source data hence the slicers working on them.

I would now like to introduce a new data source (independently generated, different data however with some of the same information- area, date, manager etc) to the dashboard that is also controlled by the same slicers- any way to do this? I have read one persons example on Mr Excel of using VB code to 'link' two slicers (click on a field in one and the same field on the other is also actuated) but he doesn't state how he did it so I am at a loss.

Any suggestions?

 

[salmonchild]

Had a thought- is it possible to have a cell populated by the text of a highlighted slicer option?

 

[bobhc]

Good day salmond

I think your second post should be a new thread, if people have looked at the first post, and at this time 17 have, they are unlikley to come back if they cannot help re the first, as thay will not know you have posted a diffrent question.

I think this link will help you for your first post

http://blog.contextures.com/archive...ultiple-pivot-tables-with-excel-2010-slicers/

and this for the second

http://www.mrexcel.com/forum/excel-questions/563503-possible-list-selected-slicer-values-cell.html