Forum Discussion

OJSADFJ1's avatar
OJSADFJ1
Copper Contributor
Jun 10, 2024

Filter using a drop-down list.

I have a sheet that I want to filter using a drop-down list. Column A is what I want to filter the sheet by which is a column with the appropriate week number and the drop-down list I want to use is on cell B2. I tried using an advance filter but it was only filtering once and whenever I changed my selection on the drop-down list, the filter wouldn't update. I am a complete beginner, and all the answers I have seen were to complicated with code which 

Resources