Button to filter data based on changing value of another cell

**speedy1013** · 06-02-2025, 10:02 AM

Is it possible to assign an action to a button so that it filters data based on the value next to the button, which itself updates based on selected slicers?

So for example, slicers Jan and 2025 are selected which control a pivot table, and then another sheet lists the top 10 sales, basically returning the first ten entries of the pivot table which is sorted by size largest to smallest.

I have a button next to each of the 10 entries. I want to click, say button 6, and this will filter the data in another tab to show all occurrences of whatever is next to button 6 at that point in time. So if “cheese” is next to button 6, then I want the user to be transported to the data tab which is now filtered by product type “cheese”.

Hope that makes sense!

**cysu11** · 06-02-2025, 10:18 AM

Hi,

welcome to the forum.

Please load you sample file, so we can understand exactly what do you mean...

BR, Alexandra

**MarvinP** · 06-02-2025, 10:18 AM

Hi speedy and welcome to the forum,

I'm invisioning having a sheet with an Advanced Filter on it, filtering another sheet's Data. In VBA you click on a number and the data next to another table is used to fill in the criteria for the Advanced Filter, which then fills in the sheet. In the newer Excel Spill functions you can do this with a single formula.

All we really need is a sample workbook, showing what your data looks like and the slicers, etc. It even seems this can be done without any VBA using the newer Spill functions. We can't be for sure without seeing what you really mean by your question. Learn how to attach a sample workbook to this thread and we can give a much better answer.

**speedy1013** · 06-04-2025, 09:56 AM

Dash Test Mockup.xlsm

Thanks for the welcomes

My actual spreadsheet has confidential information so I've recreated the basic essence of it in the attached version.

I've recorded a macro to show what I would want to happen if the "1" button on the list (on the Dash tab) is clicked, though this is based on me knowing that "D Green" is first when no slicers are selected.

When a slicer is selected and the order changes, I would want the "1" button to filter the Data tab by whatever name is now next to it, and same for the other buttons.

**MarvinP** · 06-04-2025, 10:42 AM

Hi speedy,

You could create and assign a macro for each button (see attached where I've done 2 and 3) or you could use a Double Click Event on the Name itself and pass that parameter to the code that does the work. See it in the attached also after reading this link.
https://www.bing.com/search?q=vba+pa...tsg=1&hsmssg=0

I prefer doing a double click on the name itself so I don't need to create lots of buttons and then try to figure out what might be to the right of them.
See if this works for you.

Also watch https://www.youtube.com/watch?v=DxIzTKgchJ8 and the Sheet Code Name for more hints on learning VBA.