Hi,
I need help on create dynamic drop down list. When i select Year under Dropdown-1 then corresponding Week will appear under Dropdown-2.
.
Hi,
I need help on create dynamic drop down list. When i select Year under Dropdown-1 then corresponding Week will appear under Dropdown-2.
.
Please show samples of what you expect?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Example-1
Year Week
2018 Week-Jan 1
Example-2
Year Week
2019 Week-Dec 31
So, what you want, is to select a year from A1:B1, and based on that, when you select the DD in F4, it shows you all the dates for that year?
Yes Correct
See if the attached is what you want?
It uses INDIRECT to grab the year
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks