Question: how to copy data validation from one excel to another?
Answer: Select the cell to which the validation rule applies and press Ctrl + C to copy it. Select other cells you want to validate. ...  Right-click the selection, click Paste Special, and select Validation from the context menu. ...  Click OK.