excel control slicer with cell value

[Nikhil28]

Hi,

I have multiple pivot tables and 3 slicers - Site, Year and Month

I don't want to display the slicer on the report but somehow change the slicers based on a cell value - Site, Year and Month.

Site is in Cell E5, Month, in E6 and Year in E7

How can I change the slicers based on these cell values.

Slicers are linked to 5 graphs - graph 5,6,7,10,11.

Help much appreciated.

Thanks

[Keebellah]

I like slicers, and I think they're great but never took the time to look deeper into the coding.
I googled your question and came up with this site https://www.contextures.com/excelslicersupdatevba.html
Maybe you can find something there, It's one of the many great tutorial sites. and I've implemented many of their tips in other macros
Gurious to hear what you find and if you get it working.

[margaret1]

yes. It can be changed

[Keebellah]

Usefull answer?

[rorya]

Methinks margaret is a spammer based on posting history. Don't be like margaret.