Forum Discussion
Excel - hide/unhide data based on check box.
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
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.
- 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,,, !!
