I'm trying to filter a list of of value ranges based on whether a value entered into a cell is within the ranges. After doing some research it seems my best option is to use Excel's Advance Filter feature. For some reason though advanced filtering works perfectly fine for this purpose when I use formulas that reference a specific number (example: "=340>=A5", List range A4:X50), but if I replace the specific number with a cell that contains that number the filter filters out every row in my list (Example: "=A1>=A5" where cell A1 contains 340). Is this just a limitation of the program or is there another way I can achieve the desired functionality (perhaps using a shadow table that is filled in via a macro that would fill in A1's contents into the formula)? Thanks a lot for any help!
P.S. If needed I can create a mock up of exactly what I am trying to accomplish.