I have a workbook that i’d like to hide rows on specific sheets which is triggered by changing a drop down selection.

[Sheet “Trainee Details” K11 would be the trigger:

This would trigger hide/unhide across specific sheet ranges like in this screenshot.

Sheet “COC” value “0” rows to hide:

Sheet “GS 1” value “0” row to hide:

I would like it to do this across COC, GS Syllabus, GS 1, TO Syllabus, EO Tracker, 1. if that makes sense.

I have found a few Show/Hide macros but couldn’t find something that would auto trigger this function.

My workbook is saved to my Google Drive but is an Excel file
[https://docs.google.com/spreadsheets/d/1pnw7qWhW8xyh4bumi4gbEn1mtoTEewr0/edit?us p=drivesdk&ouid=117762018305231754487&rtpof=true&sd=true ]

I hope someone is able to help otherwise i will have to look at a manual Macro command button.

I have been able to find a hide/show macro for individual sheets, but unable to get it to do what i want.