solsearcher
01-02-2008, 03:00 PM
I am using a spreadsheet that has 3 columns and about 2000 rows. I only filter column A1 (Products) and I use the autofilter > custom... 'begins with' and then I type part of my product code to find what I'm looking for.
This works well but is time consuming. I tried to create a macro to open the 'custom' dialouge box but it records the whole search which is no good for my problem.
I thought that I could create a button that acts as a shortcut to open the Autofilter Custom dialogue box but I have had no luck.
Would it be better for me to create my own form with a text field and search button?
Can somebody give me some advise please?
This works well but is time consuming. I tried to create a macro to open the 'custom' dialouge box but it records the whole search which is no good for my problem.
I thought that I could create a button that acts as a shortcut to open the Autofilter Custom dialogue box but I have had no luck.
Would it be better for me to create my own form with a text field and search button?
Can somebody give me some advise please?