On the Shifts sheet, once you have inserted the 15 rows you wanted above the OFF cell, whatever you type in those cells will appear in the drop down on your first sheet.

http://www.contextures.com/xlNames01.html

The above website should get you started in understanding how Named Ranges work.

Regards,

David


When you reply please make it clear WHO you are responding to by mentioning their name.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".