Excel - hide/unhide data based on check box.

%3CLINGO-SUB%20id%3D%22lingo-sub-2513934%22%20slang%3D%22en-US%22%3EExcel%20-%20hide%2Funhide%20data%20based%20on%20check%20box.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513934%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%20I%E2%80%99m%20working%20on%20an%20excel%20project%20where%20I%20need%20to%20hide%20some%20rows%20based%20on%20checkbox%20from%20master%20tab.%3C%2FP%3E%3CP%3EFor%20example%20%E2%80%93%20If%20use%20uncheck%20yellow%20highlighted%20from%20Master%20then%20their%20associated%20numbers%20from%20details%20TAB(Red%20colour)%20should%20be%20hide%20and%20if%20they%20check%20then%20detail%20number%20should%20be%20resurfaced.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel1.JPG%22%20style%3D%22width%3A%20504px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293345iB9E545D9BAFB92E8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Excel1.JPG%22%20alt%3D%22Excel1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2513934%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2513964%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20hide%2Funhide%20data%20based%20on%20check%20box.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513964%22%20slang%3D%22en-US%22%3EThis%20is%20possible%20by%20using%20VBA%20macro%2C%2C%2C%20if%20you%20are%20comfortable%20to%20handle%20all%20these%20the%20edit%20your%20post%20%26amp%3B%20add%20new%20line%20as%20well%20TAG%20VBA%20to%20the%20question%2C%2C%2C%20!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2513980%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20hide%2Funhide%20data%20based%20on%20check%20box.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513980%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1095018%22%20target%3D%22_blank%22%3E%40TheTallman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20considered%20a%20slicer%3F%20If%20the%20details%20is%20a%20structured%20table%2C%20then%20click%20on%20it%20and%20select%20insert%2Fslicer%2C%20which%20you%20can%20cut%2Fpaste%20to%20another%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

 

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...