Question: how to copy a list from one excel sheet to another?
Answer: Select a cell that contains the drop down list you want to copy., Copy the cell by pressing Ctrl + C or Right-click -> Copy., Select the cells where you want to paste the drop down list., Right-click, select paste special, click on Validation and press OK.