babaso_tawase
Board Regular
- Joined
- Feb 5, 2017
- Messages
- 59
- Office Version
- 2007
- Platform
- Windows
I have large data sheet about 7000 rows..in column B for every cell I given data validation list (Large list about 300 entries) for each cell in column B. I want show matching value what I typed in cell for easyness.
suppose below is master list of datavalidation
Entry sheet is like below
If I type "S" in B2 cell, it should pop up only name containing S letter', like Shyam, Suresh ,Sana, Sayan only.
suppose below is master list of datavalidation
Names |
Shyam |
Ram |
Suresh |
Sana |
Veena |
Sayan |
Entry sheet is like below
A | B |
Sr.No | Names |
1 |
If I type "S" in B2 cell, it should pop up only name containing S letter', like Shyam, Suresh ,Sana, Sayan only.