Time Sheet With Drop Down List and Auto-Fill

**deltadawn** · 11-02-2011, 11:59 AM

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.

**royUK** · 11-02-2011, 12:49 PM

Split the list into two columns. Seems a complicated way to do it, why not just use formulas on the timesheet

**deltadawn** · 11-02-2011, 02:20 PM

I am a novice with Excel - can you give me an example?

**royUK** · 11-02-2011, 03:23 PM

Not sure if this is what youy want, but it might give you some ideas

**deltadawn** · 11-02-2011, 03:41 PM

RoyUK - thank you...it was exactly what I was looking for!!! I will have to practice with VLook ups.

**ConneXionLost** · 11-02-2011, 03:52 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save