Possible to create a macro which autofilter for example +/- 2.0 relative to a given value?

Hi all,

I'm doing a lot of filtering of various tables lately and find myself wondering if there's faster ways to do it?

Typically, I'm interested in filtering values that are similar to the one I'm currently looking at (or have as my selected cell inside a range). What's similar is a subjective question I suppose, but if I'm looking at the numerical value "-9.25" I'd typically filter values that are + 2.0 points above/below.

So, I'd filter using the Between function that's built in the tables. This means that I first have to do the mental arithmetic of what's +/- 2.0 relative to my chosen number (-7,25 & -11,25). Finally, I have to enter it using my keyboard. This takes time.

Would it be possible to create a macro that does this on the fly? The filter value (+/-) could be user adjusted inside the macro or relative to a cell value. The first is perhaps easier and best.

I'd be interested in doing the same with time data (+/- 30 minutes), but I'd imagine there'd be no difference.

Uten navn.png

Thanks in advance for all and any help!

Elijah