hi experts,
i made 3 radio button with the name of "a" "b" "c" and linked to cell "a2" what i want, to control slicer using radio button,when i click "a" on radio button slicer should be automatically changes to "a" value in pivot table same with "b" and "c".
i think it could be done using Vba or formula,if any one can give both the solution using formula as well as well as vba it will be appreciated.
its urgent.
i made 3 radio button with the name of "a" "b" "c" and linked to cell "a2" what i want, to control slicer using radio button,when i click "a" on radio button slicer should be automatically changes to "a" value in pivot table same with "b" and "c".
i think it could be done using Vba or formula,if any one can give both the solution using formula as well as well as vba it will be appreciated.
its urgent.
