Good Day to you all,
Newbie here, looking for some advice
. I have a spreadsheet linked here (hope it works) Its my works training record for different areas. I could split it down to different positions but I'm sure there's a way to keep it all together. I have browsed through to see if i can find something that resembles what i'm trying to do but just cant quiet get it to work correctly.
When i change the drop down in "Trainee Details K11" it selects the data from "GS" & "EO's" to then put into "GS Syllabus", "GS 1", "TO Syllabus", "EO Tracker" and "1". I hope you're still with me. At the minute the referenced data doesn't fill all the rows and changes depending on which drop down.
Aim- I would love to be able to hide/show rows automatically when triggered by the selection of the drop down?
I really hope this can be done
Thank you gurus, any questions I will keep an eye out.
Newbie here, looking for some advice

When i change the drop down in "Trainee Details K11" it selects the data from "GS" & "EO's" to then put into "GS Syllabus", "GS 1", "TO Syllabus", "EO Tracker" and "1". I hope you're still with me. At the minute the referenced data doesn't fill all the rows and changes depending on which drop down.
Aim- I would love to be able to hide/show rows automatically when triggered by the selection of the drop down?
I really hope this can be done

Thank you gurus, any questions I will keep an eye out.