Select a range

[WelshyWizard]

Hi all,

I want to do the following:

I have two list boxes on a worksheet. One gets it's values from a list of shifts (A to D) and the other is a list of employees.

Both listboxes are populated by using a reference name associated with the range of the shifts and employees.

What I want is when you select the shift (say shift A), the only employees you see on the listbox for employees are those on shift A.

The employees are listed out on a seperate worksheet called 'Employees' and all employees have their shift in the column next to them.

Any help would be great.

Cheers.



Today is the tomorrow you worried about yesterday - and all is well.....

 

[PhilH123]

Welshy,

Take a look at this, I think it's what you're after :

thread68-947139

Phil.