200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have created a form for recording weak muscle function by using check boxes on the "Exam" Page. The weak muscles are now listed on the report page by using an "OR" formula in colum D.
How do I hide the rows that return a "False" in colum D and a blank cell in Colum C?
I want to compress the report page so it lists only the muscles that were found weak.
What I would do is one of these 2 options:
Option 1 is self-explanatory and maybe not what you want as it involves programming
Option 2: Create a new worksheet > go back to the Report sheet > select everything and hit Ctrl + C > go to the new worksheet and hit Alt + E + S + V Enter (This will turn all formulas from the Report sheet into the actual display values on the new worksheet).
Now, select columnd B to I on the new worksheet and go to the Data tab > Remove Duplicates > and hit OK.
Once you do this, it is easy to finishe the formatting as you desire. Also, it may look like a lot of steps but all of this will take less than 30 seconds once you get used to it.
I attached a sample of what it will look like if you follow the above steps - the new report is on Sheet1.
