Need help having a drop down list change multiple cells depending on the list selection

I'm just starting to learn how to use formulas in excel so I am looking for some help on having a drop down list change multiple cells depending on the list selection. I have been successful in trial and error thus far for tons of other issues, but I am stuck on this one.

I have attached an example of my problem I am working with for others to get a better understanding of what I mean.

In regards to my example, I have two shifts, D.5 Shift and C Shift. Each shift comes with different times in half hour increments and when I select D.5 Shift in the drop down, I want B8-AA8 to be populated in B1-AA1, B9-AA9 to be populated in B2-AA2, and B10-AA10 to be populated in B3-AA3.

If I were to choose C shift, I'd want B13-AA13 to be ALSO populated in B1-AA1, B14-AA14 to be ALSO populated into B2-AA2, and B15-AA 15 to be ALSO populated in B3-AA3.

Is this concept even possible? If so, how do I combat this as anything I've searched for has not properly addressed my problem.

Thanks in advance!

I don't know if I understand correctly, but try =IF($A$1="D.5",B8,B13) in B1, then copy to all cells from B1:AA3.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

With my example there are only two choices with two time grids. With my actual project, I have eight. I tried adding in more to the formula to cover eight choices rather than two and it throws an error stating there's "too many arguments fo this function"

How would I go about this? My actual spreadsheet has a ton going on and I didn't want to attach that but I will if it helps people help me.

Okay I cleaned it all up and showing is now the majority of what I am working on in regards to this formula issue I'm having.

It also depends on the day: only reference to the day is in tab name (?)

I apologize, please ignore the days. I forgot to remove those. We wont be needing any information from any other sheet within the formula, I know that much.

To clarify, please only worry about the first sheet titled "W2 Monday"

in "W2 Monday"

in C3

=INDEX(INDIRECT("'" &$B$3&"'!A1:AA24"),ROWS($1:2),COLUMNS($A:A))

Copy across and down

Or

=INDEX(INDIRECT("'" &$B$3&"'!A2:AA24"),ROWS($1:1),COLUMNS($A:A))

(as I was "fixated" on finding the day!)

Hey John, thanks for helping out!

Unfortunately, that doesn't work. It just displays 0:00 no matter what I choose.

See attached.

Ahh yup the D.5 selection works, but the rest of them don't.

Because there is no data for the other shifts!!!!!

Look again. Starting cell C12 and down is the rest of the data for the other shifts.

After hours of trial and error, I finally figured it out myself. This will be a ton of work, but I don't see it working another way. Thanks for the help anyway everyone!

In each cell that needs to be changed,
=IF(A1="D.5","10:00",IF(A1="C","9:00",IF(A1="B","9:30",""))) and so on.

No worries, it's my fault for not removing the unnecessary sheets and making it confusing. You've been a big help, thank you so much!

You are very welcome; I am of an an age where confusion comes easily!!!