Hey,
So Ive been working on my dashboard, mind you I'm very new to excel. Ive got a couple charts linked to copied pivot tables with multiple slicers "Origins, destinations, carriers ". and underneath that I've put in a "=index&match" function to Return 3 different rates based on how fast the item is flying. Its amazing so far. loving learning how to build this stuff. So down to my question... Is there a way to have an auto fill or hyperlink when I click on said "Slicer_origin" button(s), and "slicer_destination(s)" button to populate my "=index&match" search fields for said origin and destinations? Ive spent a lot of time looking up "how to link slicer options to auto fill cells" but I'm thinking this is a macro and not a function. Ive not even touched macros yet so any help with what I'm looking for would be great! thanks in advance
Bookmarks