Copy the value of a selected item in a slicer to a specific cell

[eddieebo]

I have a slicer for the months of the year which is linked to a large number of pivot charts across a workbook. On the same page I also have a specific cell, R13, which is linked to autofilters across the same workbook where the value of R13 determines the filtered value for a number of tables. These tables are related to the pivot charts that the slicer is linked to. Moreover, the filter which R13 controls is for the month of the year. That is, if I write 'November' in R13 then in all the linked tables/autofilters the data of those tables is filtered so as to return only results corresponding to the month of November.

I would very much like to know how to simply select the month in the slicer and have that month value also populate R13. So let's say that I select 'December' in the slicer, then I would like 'December' to appear in R13.

If I could directly link a slicer to autofilters then that would be even better. However, all I need is a VBA code that will enable whatever value is selected in the slicer to also populate R13 on the same page the slicer is on.

Any help would be much appreciated. Thank you.

 

[eddieebo]

In case it can be done, this is the filter update code that links to R13:

With ActiveWorkbook
Range("$A$44:$I$33517").AutoFilter Field:=5, Criteria1:=Worksheets("Detail").Range("R13").Value
End With

If it is possible to simply change Criteria1 to whatever is selected in the Month slicer on the sheet "Detail"; that would be fantastic. This might cause an issue though if multiple months were selected on the slicer as it would then need appropriate coding for Criteria2 to Criteria12 so as to appropriately filter by every month selected.