I have a sheet named "Line2" which has my data in it. In Column D, it has Area in it and in column E, it has Equipment type in it.
On another Sheet named "Final Log", in column C i have same Area in it, but user select through drop down.
I want when user select area from drop down in Column C, its related data(from sheet Line 2) should come in Column D(but in a drop down) and same goes for column e(Equipment ID)
when selected by user from drop down, it should show its related data in column E(Equipment ID) in a drop down. Please Help
Attached are snapshot and file
Bookmarks