Nighthawk_NL
New member
- Joined
- Feb 7, 2020
- Messages
- 5
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- 2019
I have been reading and watching a lot of possible solutions online lately, but unfortunately I can't figure it out. Perhaps it is not possible at all in Excel what I would like to do.
On the "Basic" tab Column C (## Supplier ##) I want to be able to type e.g. Europe in row C2 and then like to get an overview of all Suppliers that contain the word Europe and I can easily select the correct Supplier.
It would also be very handy that if I enter the letter A that Excel will only show the lines that start with an A and / or a certain word such as Europe and that Excel will only show the dropdown data that contains this word. I want to be able to extend the search function to all the cells below.
This also applies to Column E (## Label ##). For example: When I type Software in Excel, it shows everything that contains the word Software so that I can easily select the correct label.
Finally, in Column G (Genre) when I type in Mouse Excel gives an overview of all Genres in which the word Mouse appears and I can easily select the correct Genre.
I hope that what I want is actually possible in Excel and that someone could help me with this.
In any case, many thanks for your help.
On the "Basic" tab Column C (## Supplier ##) I want to be able to type e.g. Europe in row C2 and then like to get an overview of all Suppliers that contain the word Europe and I can easily select the correct Supplier.
It would also be very handy that if I enter the letter A that Excel will only show the lines that start with an A and / or a certain word such as Europe and that Excel will only show the dropdown data that contains this word. I want to be able to extend the search function to all the cells below.
This also applies to Column E (## Label ##). For example: When I type Software in Excel, it shows everything that contains the word Software so that I can easily select the correct label.
Finally, in Column G (Genre) when I type in Mouse Excel gives an overview of all Genres in which the word Mouse appears and I can easily select the correct Genre.
I hope that what I want is actually possible in Excel and that someone could help me with this.
In any case, many thanks for your help.