Drop-down list

[Martin_H]

Hi there,

I have a sheet named Workers with 2 columns. Each column has around 1000 rows. Under the column Shift (B clomun) there are only 3 options: mornig, evening, afternoon. Under the column Name (A column) are names of workers (example below).

Name	Shift
John	morning
Paul	evening
Michael	afternoon

Then, there is another sheet named Shift_Book with drop-down list located in the cell B2. Inside this drop-down list I can choose between shifts (morning, evening, afternoon).

Inside the sheet Shift_Book there is a range B5:B50. Inside this range, in every single cell, I want to have a drop-down list of names, of workers from sheet Workers based on the value in sheet Shift_Book in the cell B2.

So for example. If I select morning from the drop-down list in the cell B2 in sheet Shift_Book, I want to see workers that are working on morning shift inside drop-down lists in the range B5:B50.


Is that possible?

 

[Fluff]

Yes that's possible, it's called dependant drop downs. Have a look here How to make a dependent (cascading) drop-down list in Excel