Quote (Orv @ Mar 3 2019 05:55pm)
I'm back to this project.
Is it possible to auto filter based on the value of another cell? H4 and J4 are selected via another sheet. I would like to be able to filter the data based on these selections.
https://i.imgur.com/ToY559R.pngWhat I would like to do now is, if H4 and J4 are filtered, I would like to be able to display the top 10 possibilities of Column D, sorted an a descending order
The only way I think this is possible is through VBA or an extension. I did some quick googling and came across the below link which has some VBA code that seems to do the trick, but I haven't ever done anything like this before.
https://www.extendoffice.com/documents/excel/3656-excel-autofilter-based-on-cell-value.htmlVBA is basically a programming language that allows you to create macros or automate things within excel. First you would need to allow the Developer ribbon within Excel. This link below should walk you through how to do that.
https://www.techonthenet.com/excel/questions/developer_tab2013.phpI would then use the insert button on the developer ribbon to add a button somewhere on your sheet, maybe just below the cells you want to filter by. I think you then right click the button and click either properties or assign macro (I don't have Excel installed on this computer, so working off memory haha) and then when you are assigning the macro there is a button for "New Macro" which will open up a new page similar to the screenshot in the first link where you can paste that VBA code in (remember to change the cell references).
Then essentially it will run that code and filter the results every time you press the button that you assigned that Macro to.
I don't have a great deal of experience with VBA, but know some of the general basics if you get stuck.