Automatically Filter Table to Match Between-Number Criteria

[kcratskcor]

Hello! This is my first post here as I am new to Excel.

I am looking for a way to automatically filter a table of numbers. I need to filter each column so it it only shows numbers that are within a certain range. As seen in my image, I need the table to only show me rows in which column A is between 109&105, column B between 104&100, column C between 97&93, and column D between 104.2&100.2. I can accomplish this by filtering each column individually with the "Between..." option but this is very time consuming to do with all four columns. I have tried using the Advanced Filter option but couldn't integrate anything that understand the range of numbers I want. Thank you for any and all help!excel.jpg

[JBeaucaire]

Anything "automatic" would require VBA. To do that, we would need your workbook.

If VBA is ok to implement, attach a sample workbook. Remember to desensitize the data if necessary since this post will remain for others to benefit from in the future.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.