As the title states, I need to filter two columns based on values that are input in another worksheet. One of the cells is a drop-down box. I want the filter to work so that if I type in "N1" for column A and "D1" for column B, only rows that contain both will be shown. Right now I am simply trying to find a code that works within one worksheet, but to no avail. It filters values, however it ignores previous filters applied (if I wrote N1, then D1, all values of D1 will be shown instead of only the ones corresponding to N1). I cannot figure out how to apply both filters at once. Here is the code I am currently using:
Bookmarks