Hi,
Apologies if This thread has already been posted but struggling to find anything which has helped me.
I am looking to Have a combo box which dives the weeks selection in my privots on my master sheet.
I.e. If I select 8, I would like all the pivot tables in that sheet (three of them) to change to the same week as in the combo box?
Any ideas?
Any help appreciated...
Apologies if This thread has already been posted but struggling to find anything which has helped me.
I am looking to Have a combo box which dives the weeks selection in my privots on my master sheet.
I.e. If I select 8, I would like all the pivot tables in that sheet (three of them) to change to the same week as in the combo box?
Any ideas?
Any help appreciated...