Jul 03 2021 10:12 PM - edited Jul 03 2021 10:50 PM
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
Jul 03 2021 10:36 PM
Jul 03 2021 10:53 PM
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.