Forum Discussion
Excel searchable combobox
I've been waiting for somebody with knowledge of the Combo Box methodology to respond, but after six hours decided I'd jump in to ask you for a few more details on exactly what you're trying to accomplish.
The reason I'm asking is that with the far simpler Data Validation method, combined with the newly available Dynamic Range functions in some creative ways, I think it's possible to do a lot of things that Combo Boxes used to deliver. Maybe not everything...as I said, I'm not really familiar with them...
But if you can spell out what you're trying to do (i.e., give some examples of what's in the basic or central one; what would be an example of the linked "secondary" boxes, etc., maybe we can come up with a simpler solution.
mathetesSo my company has a PDF of all the materials we can order that we need at work. I can search the PDF but I want to just type what I need and have it populate in the form I created. That part works but now I want the adjacent cells to autopopulate with the item number that correlates to it and also the unit of issue i.e. EA, PK, FT...… I'll try to attach a screen shot of my spreadsheet.
Thanks