Update Slicers with Date

Hi all,

I'm having a problem trying to update multiple slicers in Excel and with different date range and would like to ask for your expertise.

First of all, there are three sheets where
Sheet1 should pick a single day
Sheet2 should pick Month-to-Date
Sheet3 should pick Year-to-Date

I record a macro to see how the code would look like when clicking a particular date in the slicer manually and here is the code:

Please Login or Register  to view this content.

My question is, is there a way to reference the date to a particular cell and then the macro will run all 3 sheets accordingly?

Something similar to the code below where user will input the date in cell Q3:

Please Login or Register  to view this content.

Thank you so much!

Please edit your post to nest code inside the tag (# button in the tool bar).

Also, please upload a sample workbook (desensitized data), along with detailed explanation of what the code should do.
I'm not sure I get your requirement.

Here, try this. Tested and working on my end using OLAP based pivot & slicers.

Please Login or Register  to view this content.

Edit: Change the reference cell for dtPicked as needed.