In an attempt to streamline, I'm wondering if there's a way to add a "search feature" to a sizable workbook.
I'm looking for help with a project (I know VERY little VBA). I'd like to have two tabs: tab 1 the dataset, tab 2 the 'search criteria and results listed.'
Tab 1 has the same three columns as below - just 50k+ rows.
On tab 2, I want to have the ability to enter partial names/numbers into the "search criteria," and then have the results listed in a table below.
A few other points:
1. Not all three search fields will be used each time
2. each field needs to search as a the corresponding cell as a sting omitting spaces, dashes and slashes
The idea is to find a "short list" of possible items (Manf/device/mdl#) that will then be copied onto a different file for consistent nomenclature and further processing. Using the main dataset's filters work to a point, but I'm hoping for something better.
Below are a couple sample representations of what I'm trying to do.
I'm looking for help with a project (I know VERY little VBA). I'd like to have two tabs: tab 1 the dataset, tab 2 the 'search criteria and results listed.'
Tab 1 has the same three columns as below - just 50k+ rows.
On tab 2, I want to have the ability to enter partial names/numbers into the "search criteria," and then have the results listed in a table below.
A few other points:
1. Not all three search fields will be used each time
2. each field needs to search as a the corresponding cell as a sting omitting spaces, dashes and slashes
The idea is to find a "short list" of possible items (Manf/device/mdl#) that will then be copied onto a different file for consistent nomenclature and further processing. Using the main dataset's filters work to a point, but I'm hoping for something better.
Below are a couple sample representations of what I'm trying to do.
Search Criteria | |
Manf | GE |
Device | |
Mdl # | 52 |
Manf | Device | Mdl# |
3Gen Inc. | 52 F | |
Aerogen | CDL 1521 | |
GE Appliances/Hotpoint | 56077852 | |