Question: how to copy excel sheet with data validation?
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.