Hello There,
I have 2 columns, ID (Column C) and Name (Column D). Labels are on the 5th row and data starts from 6th row
I have made the cell D3 where the you can enter the partial string of the name. A button next to it.
When you press the button 'Search', it should display all the names that matches the entered string. I would not like to use a table.
Attached is the sample workbook for your reference.
Could you advise and help, how this can be achieved through VBA?
I have 2 columns, ID (Column C) and Name (Column D). Labels are on the 5th row and data starts from 6th row
I have made the cell D3 where the you can enter the partial string of the name. A button next to it.
When you press the button 'Search', it should display all the names that matches the entered string. I would not like to use a table.
Attached is the sample workbook for your reference.
Could you advise and help, how this can be achieved through VBA?