Automatically selecting the next option in a drop down menu.
 

Thank you in advance for your help with my question. I have a
spreadsheet that contains a drop down menu containing dates. Each
week, I manually choose the next date in drop down menu. Is there a
macro that will automatically choose the next date in the drop down
menu?

Thanks,

Kirby