I was wondering if anyone had suggestions on how to go about creating an interface to allow people to search by category and/or name of a company which would then pull up certain records into text boxes on the interface! Any suggestions would be grateful thank you!
Asked
Active
Viewed 70 times
0
-
this is a really a `desgin a system for me question` which is a bit out of scope, but see `PivotTables` or `vlookup`, `index/match`, or maybe `SUMIF` depending on your needs – Scott Holtzman Jun 29 '16 at 20:48
-
Is this kind of what you are looking for: http://stackoverflow.com/questions/37572688/auto-complete-with-only-text-and-not-numbers-combobox-excel-vba/37620203#37620203 Let me know if this solved your problem. – Ralph Jun 29 '16 at 21:09
-
Ralph it did answer my question thank you! – xdiz1231 Jun 30 '16 at 16:23
-
And thank you Scott for your input as well. Pivot Tables were helpful also – xdiz1231 Jun 30 '16 at 16:24