Time Sheet With Drop Down List and Auto-Fill

[deltadawn]

I have a workbook with 2 worksheets - one sheet is a time sheet (timesheet) and the second sheet is a list of week-ending dates and week numbers (calendar).

In the time sheet, when you add the week-ending date, it auto-fills the dates next to the weekdays.

My problem is that I'm unable to make the WEEK ENDING field in the timesheet, a drop list of the calendar items without screwing up the auto-fill dates next to the week days.

I am uploading the file for review.