Autofill rows based on drop down selection

[Jet Fusion]

Hi

How would I be able to extract the row of info from the data sheet to the rows for that selected cattegory on the dashboard sheet. Each Cattegory could have more rows & coloums added in future.

It should show the whole range within that cattegory on the data sheet.

Thanks
Jet

 

[Basavaraj K H]

Refer attachment maybe your searching the same, I altered some date.

 

[Jet Fusion]

@Basavaraj K H thank you so much you saved my life