Excel - hide/unhide data based on check box.

Copper Contributor

Hi All, I’m working on an excel project where I need to hide some rows based on checkbox from master tab.

For example – If use uncheck yellow highlighted from Master then their associated numbers from details TAB(Red colour) should be hide and if they check then detail number should be resurfaced.

Pls confirm how i can do through VBA/MACROS

 

Excel1.JPG

2 Replies
This is possible by using VBA macro,,, if you are comfortable to handle all these the edit your post & add new line as well TAG VBA to the question,,, !!

@TheTallman 

 

Have you considered a slicer? If the details is a structured table, then click on it and select insert/slicer, which you can cut/paste to another worksheet.

 

https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-126517...