range depending on selection

[swfarm]

Hi Guys

Please see attached

What im looking to achieve is - dependant on what is selected on M4
Then the range under that heading fills the boxes underneath M4 ( M6 onwards ) with whats underneath that name
so in the example provided it would return

Colour in
Colour Out
Sill ?
Hardware
Letterbox

but if uWindow was selected it would return

Colour in
Colour Out
Sill ?
Hardware
Glass
Restrictors


If anyone could help this would be greatly appreciated

[modytrane]

Simple way to do it is with a formula.
In M6 and drag down.

[swfarm]

Hi Mody Trane

Thank you for the reply that works great with the exception it leaves zeros in any unused cells is there a way round this please?

thank you

[swfarm]

Sorted Mody trane

deselect the show zero