Normally. I do this by using a pivot table and overlaying it with a named range.
I wanted to give my users the ability to enter part numbers with wildcards in a form, populate a list box and give them a chance to select a part for further analysis. I get as list of unique parts as a data download and want my users to have a way to look at all the 3500-series parts for example.
The subroutine takes three inputs: an input range (to read from), an output range (to write to) and a pattern to match.
Here is the code:
Please Login or Register to view this content.
Bookmarks