So I was going through methods of how I can make this thing work. Provided below is my attempt to thoroughly explain my issue, and below that is my sample excel.
I'd like to autofilter a table entirely dependent upon user input in a cell. To do this, I thought that I'd need to place their input in a seperate location, with an operator "< or >", then have the autofilter update from that cell position. Also, the way my data was input creates a problem for me. For each possible bore size (Column A), there are several Rod Sizes (Column B), and each has a different "Push" and "Pull" value. If the push force isn't above the threshold, then I would like it if the rod sizes of that bore were removed also, even if they are above the "Pull" threshold.
My first question: Using a macro that activates when a button is pushed, how can put the value input into the cell next to it and insert a ">" or "<" operator?
Second question: How do I get my filter macro to understand that the bore and rod sizes are related, so that if the bore size isn't large enough, it's relative rod sizes are also filtered?
Cylinder Calculation Sheet.xlsx
Update: Discovered the answer to my first question: Code is provided below:
Bookmarks