I have a project plan that breaks out each week of the year as a column. I have a data validation list at the top that allows me to select which week I want to highlight. So, if I pick "Week 3", it will highlight the column of the roadmap that corresponds to Week 3. For dates later in the year, I'd like to have this also scroll to that column. So, if I selected "Week 32", not only will Excel highlight that column (which I already have working), but also for Excel to scroll over to the column it just highlighted.
Any ideas?
Any ideas?