In my previous blog post, I showed How to Create a Simple Drop Down list in Microsoft Excel 2013 using the data from the same worksheet.
In this blog post, I will demonstrate how one could create a Drop Down list in Microsoft Excel 2013 to use Data from different Worksheet.
How to Create a Drop Down list in Microsoft Excel 2013 to use Data from different Worksheet?
1. Let’s enter the following data in the worksheet 1
A1 – Senthil Kumar
A2 – Senthil
A3 – Kumar
A4 – isenthil
A5 – Senthil Kumar B
3. Now, go to the Worksheet 2 and select the cell/column where you want the dropdown list to be shown and then click the Data Tab.
4. Navigate to Data Validation Dialog by clicking the Data Validation button from the Data Validation combo box defined in the Data Tools.
6. Now, you should see the dropdown list being created in the selected column of the excel worksheet 2 with the predefined values from worksheet1.