I am trying to figure out how to have a user definable easy to fill out filter option and I can't figure it out to be easy on the user end....(like boxes to fill out and then the sheet auto sorts for those options but just for that user and no one else)
Like if I wanted to sort by value or price, or output at x hz, I could select that. Then enter a min and a max value.
I know I can do this by defining the filter above in post 118, but to just have like a drop down for the column headings to choose what you want to sort by, then enter your min and max.
Something like what I have highlighted in blue on the lower right side (not here but just was where I was trying to get it to work)
Like if I wanted to sort by value or price, or output at x hz, I could select that. Then enter a min and a max value.
I know I can do this by defining the filter above in post 118, but to just have like a drop down for the column headings to choose what you want to sort by, then enter your min and max.
Something like what I have highlighted in blue on the lower right side (not here but just was where I was trying to get it to work)
Last edited: