Excel - hide/unhide data based on check box.

Occasional 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



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,,, !!



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.