Can a Macro utilize an auto filter?
I have column in my spreadsheet and it already has an autofilter associted
with it. I use the custom auto filter function to do a "contains" search for
a particualar string I am looking for. I was wondering if I could create a
macro that is associated to a button that does the same thing? I want an
un-experienced user to be able to type the string they are looking for into a
text box, click the button, and all the fields in that column that contain
the string will appear. Is this possible?
|