Searchable Drop down list using a cell

[Kunal Ravi]

Hello,

Plz some one help me

I have a list of employee’s name in a column A- Sheet1

I have to select / choose an employee from a Cell on Another Sheet — 2, and countinue to its downward cell also

Plz help me

 

[Zubair]

Hi Kunal,

You can use Data validation in Sheet 2 using range of Sheet1

Mr. Excel help.xlsx
	A
1	List of Employee
2	Employee 1
3	Employee 2
4	Employee 3
5
6
7
Sheet2

Cells with Data Validation
Cell	Allow	Criteria
A2:A7	List	=Sheet1!$A$2:$A$41

 

[Kunal Ravi]

Hi Kunal,

You can use Data validation in Sheet 2 using range of Sheet1

Mr. Excel help.xlsx
	A
1	List of Employee
2	Employee 1
3	Employee 2
4	Employee 3
5
6
7
Sheet2

Cells with Data Validation
Cell	Allow	Criteria
A2:A7	List	=Sheet1!$A$2:$A$41

Zubair, first of all thank you
Will it be possible with autocomplete and automatically comes this function in next row

 

[Akuini]

@Kunal Ravi
In case you or anyone else are interested.
I created an Excel add-in for searchable data validation (with combobox) , called "Search deList".
Its function is to speed up the search in the data validation list. It works on multiple cells. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.
It works on any cells that have data validation on any workbook, and you don't need VBA for this.
I share this add-in here:

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

 

[Kunal Ravi]

@Kunal Ravi
In case you or anyone else are interested.
I created an Excel add-in for searchable data validation (with combobox) , called "Search deList".
Its function is to speed up the search in the data validation list. It works on multiple cells. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.
It works on any cells that have data validation on any workbook, and you don't need VBA for this.
I share this add-in here:

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

Thank you Akuini
I hope it will work