Hi!
I have tried to overcome this challenge by using INDEX+Match. That did work, but then I need to hard code in the names and I need a dynamic "on the fly" way. After reading much, I found out that the INDIRECT would solve my problem, but this issue is just above my current knowledge and I fail all the time.
Challenge 1
In the worksheet “Overal campaign information” I have these 3 cells:
I would like to enable dynamic drop down lists in column F where the list is populated based on the existing values from the other worksheets name “Week x xxxxxx”.
Example:
Scenario for example:
Year = 2019
Week values should just then show me 3,11 and 12.
Type values should just show me “CPC and Email”.
These values are capture from the other worksheets named “Week xxxxx” and from cell C10 (Week), C11 (Year) and C13 (Type)
Challenge 2
When I have selected my values from challenge 1, the information from that selection should be inserted into C8:C13 from that current worksheet and B17:V300
Scenario Example:
I have attached my dummy file.
Thanks in advance for any help on this!
I have tried to overcome this challenge by using INDEX+Match. That did work, but then I need to hard code in the names and I need a dynamic "on the fly" way. After reading much, I found out that the INDIRECT would solve my problem, but this issue is just above my current knowledge and I fail all the time.
Challenge 1
In the worksheet “Overal campaign information” I have these 3 cells:
- Week (E2), Year (E3) and Type (E4) with their respective values in column 4 (F)
I would like to enable dynamic drop down lists in column F where the list is populated based on the existing values from the other worksheets name “Week x xxxxxx”.
Example:
- Year: I have the values 2019 and 2020
- Week: For 2019 I have values 3,11 and 12. For 2020 I have value 4.
- Type: For 2019 and week 3,11, and 12, I have values “CPC and Email”. For 2020 and week 4, I have the value “Email”.
Scenario for example:
Year = 2019
Week values should just then show me 3,11 and 12.
Type values should just show me “CPC and Email”.
These values are capture from the other worksheets named “Week xxxxx” and from cell C10 (Week), C11 (Year) and C13 (Type)
Challenge 2
When I have selected my values from challenge 1, the information from that selection should be inserted into C8:C13 from that current worksheet and B17:V300
Scenario Example:
- Values selected: Year = 2019, Week= 3 and Type = Email
- Then in the cells from C8:C13 and B17:V300 should then capture the information from the worksheet called “Week 3 – Email”.
I have attached my dummy file.
Thanks in advance for any help on this!
Last edited by a moderator:
