Dependent drop-down list

[Dendras]

I have worksheets named Day 1 and Day 2 and a worksheet named "Workbook Master" where I would like to have three drop-down lists;

1. The list at Cell C2 should get values from cell C10 from the Worksheets named "Day ".
2. The list at Cell C3, should get values from cell C11 from the Worksheets named "Day " AND that corresponds to Cell C2. (Unique values)
3. The list at Cell C4 should the values from C13 from the Worksheets named "Day " and that corresponds to Cell C2 and C3 (Unique values).

My worksheets have this name syntax:

• Day 1
• Day 2
• Day 2 - lorem
• Day 2 - Ipsum

Therefore I would need a "wildcard" function to search through sheets named "Day "

 

[Nebu]

Hi:

This is a frequently asked question in this forum, do a search in here you will get what you are looking for....

Thanks

 

[Dendras]

I found a lot of information here, but, my challenge is that to make a dynamic list that searches through all worksheets the starts with "Day " I can't find any solution to that

 

[Dendras]

If you see at the attached file in sheet "Overal campaign information" there you will see C2:C4 where i need to make the depended lists.

Could one solution be that one can make a formula in sheet "Div" that gathers these values dynamically (if I make a new worksheet, it will capture the information) and then easily make a depended list ?

 

[vletm]

Dendras
My worksheets have this name syntax ...
... is that syntax changed? There are 'Week '-sheets.

Why there should be 'Week 'ly -sheets?
... if Your data is in 'Stock Information', which could have 'date'-information?
... ... could You get those from it?

After those ... could figure 'dropdowns' ...

 

[Dendras]

Hi vletm!
Sorry, attached is the right sheet.

The setup here is that one makes a new worksheet per activity (in this case, CPC, email and so on), therefore Day 1 - CPC, Day 1 - Email.

The stock information sheet does not have that data :|

In sheet "overal campaign information):
- C2 shall capture the unique values from C10 from all "Day xxxxx" sheets
- C3 shall capture the unique values from C11 from all "Day xxxxx" sheets AND corresponds with C2 (C10)
- C4 shall capture the unique values from C13 from all "Day xxxxx" sheets AND corresponds with C2+C3

 

[vletm]

Dendras
The setup here is that one makes a new worksheet per activity ...
Yes ... as long as those sheets have same layout then ...
1111 activates later You'll have 1111 more same layout sheets ... hmm?

The stock information sheet does not have that data :|
Yes ... only SKU seems to be non-formula!

>> Have You ever heard about filtering? <<
= You would need ... at least one sheet for all ... hmm?

DropDown isn't solution for this ... anyway not with me!

 

[Dendras]

I see what you're saying about 1111 more sheets. How would I make a one-sheet solution with a dropdown for time (day, Year) ?

 

[vletm]

Yes ... 1111 more sheets also that
every those sheet has ~ 6000 formulas ... ouch!

I cleaned 'a little' Your file...
I still left 'div'-sheet.

Because, I didn't notice You master plan ..
You should start ... hmm ... almost from the begin ...

Could You try to figure
a) what do You need to see ... how to see ...
> all needed information from ONLY 'Stock Information'-sheet
> what columns need to add there

b) Which parameters You use to FILTER needed data?