I have a workbook with the following sheets: Summary, Monday, Tuesday, Wednesday, Thursday, Friday, CR ATT and FC ATT.

The Summary sheet includes PivotTable reports based on the data input into tables on each weekday sheet.

The purpose of the workbook is to keep track of time spent on activities throuought the day.

Due to cross-training in the office, I want to create the ability to include separate ATT worksheets for each team (CR ATT and FC ATT) which are the sources of my data validation lists as well as some formulas. The basic idea would be the user choses the department, then the data-validation list is updated to include just that info.

I know if I was in Access, I could easily make the drop-down choices dependent on another drop-down or a check box. However, I cannot seem to figure this out in Excel.

I've been using some code I found here (http://www.contextures.com/xlDataVal11.html) to make the data validation list a combo box with the autocomplete feature. I use it in the BeforeRightClick procedure instead of BeforeDoubleClick though.

I was going to try just having multiple columns of different data validation lists, but that disrupts the above code. Is there a better way to code like above and do what I am wanting to do?