You want to duplicate the data validation rule on the other worksheets. Select the range D12:D40 (if needed) and click Copy. Click the Week 2 sheet tab and group Week 2, Week 3, and Week 4 sheets. Select the range D12:D40, click the Paste arrow on the Home tab, select Paste Special, click Validation in the Paste Special dialog box, and then click OK. Ungroup the sheets. Note: Paste Special validation is not available on Excel for Mac. Excel for Mac users need to repeat Step 5 to create validations on the Week 2, Week 3, and Week 4 worksheets