Please find my requirement.
I have a file (Sample Data) where i have 2 Worksheets Template & Data.
In Data Work Sheet i have Group in A Col. and Tower in B Col. and the parameters for that particular group and tower in the rest of the Columns from C to R
In Template Work Sheet i have the same parameters which are there in Data Work Sheet (C to R Columns [C3 to R41]) but in the vertical order.
I have 2 Drop Down Validation Functions in F4 (Tower) and G4 (Group).
My requirement is that the Validation Drop Downs should work individually. If I select tower from 'F4' based on the parameters E6 to E21 it should pull the details of the particular Tower Selected from Data Work Sheet and parameters (C3 to R41) and display it in the Template.
And for that particular Tower i would like to display the Parameters Group Wise as well and the Groups will be selected throught Drop Down G4.
Please help me in finding out a solution for this.
Sample file attached.