duteberta
Board Regular
- Joined
- Jun 14, 2009
- Messages
- 87
- Office Version
- 365
- Platform
- MacOS
Is there a way to create a dropdown of YEAR values whose MIN is any given year (say 2013) and whose MAX value dynamically changes to the Current year + 1?
So let's say that today is in 2024 so the dropdown would show values descending from 2025-2013. Then next year those same dropdown values would AUTOMATICALLY change to 2026-2013. I want this to happen without adjusting the code every year. Hopefully no VBA on this- but if need be then ok.
So let's say that today is in 2024 so the dropdown would show values descending from 2025-2013. Then next year those same dropdown values would AUTOMATICALLY change to 2026-2013. I want this to happen without adjusting the code every year. Hopefully no VBA on this- but if need be then ok.