Martin_H
Board Regular
- Joined
- Aug 26, 2020
- Messages
- 190
- Office Version
- 365
- Platform
- Windows
Hi,
I have 2 dropdown lists in cell A2 and B2. Both dropdown lists shows week numbers from 1 to 53. Column A is a starting point (FROM) and Column B is a ending point (TO).
Dropdown list in A2 will always shows all weeks (from 1 to 53) but dropdown list in B2 will only show weeks that are greater or equal to current A2 selection.
For example, if I choose WEEK 10 in dropdown list A2 I want to see only WEEK 10 and greater in dropdown list B2.
Is is possible?
Thank you!
I have 2 dropdown lists in cell A2 and B2. Both dropdown lists shows week numbers from 1 to 53. Column A is a starting point (FROM) and Column B is a ending point (TO).
Dropdown list in A2 will always shows all weeks (from 1 to 53) but dropdown list in B2 will only show weeks that are greater or equal to current A2 selection.
For example, if I choose WEEK 10 in dropdown list A2 I want to see only WEEK 10 and greater in dropdown list B2.
Is is possible?
Thank you!