Would appreciate help with a routine that will move/scroll the screen to the first date in a list of dates triggered by a dropdown selection.
Attached is a sample wkbook where the sheet has Freeze Panes applied so the headings will remain visible. When the user selects a month name in the dropdown, the screen will scroll to the first date found of that month. And, the first date may not be the first day of that month (i.e. 2/5/16, 5/5/16).
The list of dates will extend down beyond the extent of the sample range shown as dates will be added to the list.
Let me know if this description is not sufficient.
Thank you,
Delain
(There are no macros currently in the xlsm; just saved in that format anticipating a workbook code event.)
Bookmarks