Hi
I really need help here plz.
I have sheet and in that sheet there is few coloums A(Station), B (Supervisor)
and the 2nd sheet there is Few coloums A(Station), B(line), C(Line
Supervisor).
and 3rd sheet is all the main work going to happen!

My Question is how to create combo box so when i select Station it then
next to it show the supervisor of that station and lines of that station and
the line supervisor.

I know it bit complex but i have already figered out how to select station
and show the supervisor but i do not know how to show the line and the line
supervisor at the same time.

Thank u and i will be look forward to hear from u all.