Hide/ Unhide Rows based on Text Value - Checkbox

Hi All,

Can someone please help me to hide/ unhide rows on another sheet based on Text Value?

For example, if 'Purchase Order' is enabled using a checkbox or a button, then rows containing 'Purchase Order' in a specific column, in this case Column D, will be shown.

Note: I am trying to make a dashboard (sheet 1) in which specific documents can be toggled to show rows in sheet 2.

Please see attached images as reference.

Thanks!

sheet 1.jpg
Sheet 2.jpg

Hi Ali,

Thank You, that would be very helpful, my apologies.

I have read up on structured tables and slicers, but I am not sure how that will help in this case. Please can you elaborate?

My objective to be able to click on a checkbox, for example specifying 'Purchase Orders' and then in the other sheet, all Rows with the value in Column D will be shown. This is to bring up information regarding 'Purchase Orders'.

I have been trying to macro the checkboxes, but have been struggling. It would be very helpful if you can give me a sense of direction.

Thanks!
Joseph