Automatically Hide Rows in Excel Based on Multiple Conditions Based on a Cell Result

[@adnantahir4530]

Brilliant work

[@IntegratedSchoolForms]

thanks

[@TedMulder]

This worked great - really appreciate it! I am having trouble to Copy a tab in my spreadsheet. The Macro doesn't work when I copy the tab. I get a: "Compile error: Invalid outside procedure" and can't figure out what is wrong. Can you help me?

[@IntegratedSchoolForms]

That depends as to where the macro is assigned as an active sheet and where it is executed within the spreadsheet.

[@TedMulder]

@@IntegratedSchoolForms I am getting a multi use error. Do you recommend that for every tab that I have the BUTTON, that I have a macro for it OR is there a quick way to code in that I have 20 tabs and want them to all use the same macro (but have the button on each tab). Does that make sense?

[@IntegratedSchoolForms]

If you wanna use the same macro for all the other tabs then you need to make sure that all tabs have the same parameters with which you wish to hide the rows for. Considering that the macro is reading the helper columns to identify which rows to hide and unhide. Secondly, the macro must be set to ActiveSheet instead of sheet name so that whenever it is run from the tabs, it will be functioning the same way. And lastly, yes, there must be a dedicated button for each tab to run the macro.

[@azhkel]

Nice content sir

[@IntegratedSchoolForms]

thanks sir!

[@closeuptrading]

appreciate the tutorial go it working, but how to unhide the rows after clicking the button, i thought by clicking it again would do it, but did not, do i need another macro if i want the hidden cells to show

[@IntegratedSchoolForms]

yes, you'd need to have another macro for that.. i believe I mentioned in the video to just create another button, and then just use the record macro button and proceed with unhiding all the rows by highlighting all cells (CTRL A). that would immediately create a macro code for your unhiding of rows.

[@nk8404]

What is error 424 and its showing object required

[@IntegratedSchoolForms]

Error 424 in Excel VBA is a runtime error that occurs when the program tries to reference an object that doesn't exist or is not recognized by the system. The error message "Object Required" is shown when the program tries to use an object variable that has not been set or initialized.

[@archboyd]

Pretty good, it also hid the female row as well.

[@IntegratedSchoolForms]

the function will read the data based on the helper columns which were created :)

[@TheRiddlerabz]

ok this doesnt unhide though does ? once i push the button, pressing it again does not unhide ??

[@IntegratedSchoolForms]

it doesn't. And I believe I already mentioned that in the video's latter part. Unhiding the rows would require another button and you can just use the macro record option to select all cells and then unhide rows.

[@mangubatrechellec.9456]

What if you want to show it again? or need to unhide manually? thanks sir

[@IntegratedSchoolForms]

i believe we suggested that in the video using record macros

[@Jabz-93]

I have the same issue i don’t know what part are you talking about, i cannot show them again

[@Jabz-93]

When i closed my excel file and reopened it my macro script disappeared and the button no longer worked even though i saved the file before closing, any clues ?

[@WEDZMERMUNJILUL]

You should save the your excel file as .xlsm or .xlsb to keep the macro working even when you close it.

[@grisheldamarks-webster-noa1706]

Hello, How can I automatically hide rows based on a cell value without VBA codes? I can not use macros. Thanks

[@IntegratedSchoolForms]

How come you can't use macros? There ain't any automated way to hide rows based on cell values, as far as I know.

[@vytalbusinessconsultants3051]

Hi, Thank you for sharing this tutorial... A question, how to hide a row based on values in different cells of different columns... e.g I want row #2 to automatically hide if cell B2 cell value is "O" or if cell C2 cell value is "P" or if cell D2 cell value is "Q" ...

[@IntegratedSchoolForms]

you can use a conditional argument in your helper column with an OR syntax: =OR(B2="O",C2="P",D2="Q"), the return value of this conditional argument may be true or false which can be assigned with "1" or "0" in the vba reference.

[@aayushshrestha7990]

Run-Time error 1004? And on clicking button ×400?

[@IntegratedSchoolForms]

"Runtime Error 1004" is a common error that occurs when a macro or VBA code tries to access a worksheet or range that does not exist, or when the user does not have permission to perform the requested operation. Here are some possible causes and solutions for "Runtime Error 1004": Invalid range or worksheet name: If the code tries to access a range or worksheet that does not exist or has an invalid name, it will result in a 1004 error. Make sure that the range or worksheet name is spelled correctly and exists in the workbook. Locked cells or protected worksheet: If the code tries to modify a locked cell or a protected worksheet, it will cause a 1004 error. You can unlock the cells or unprotect the worksheet before running the code, or modify the code to work with the protected worksheet.

[@omek077]

Hello my friend, thank you for the tutorial it was very helpful. is it possible to tell me how i can do this button to Hide and Unhide the rows ? with your commands i can hide them but i can not unhide the hidden rows

[@IntegratedSchoolForms]

I'm not sure if I mentioned it in the video but to unhide these rows would relatively be easy just by using the record macro button. you basically hit the record macro button, highlight all the rows (both hidden and unhidden rows), right click the row numbers, choose the show all rows (unhide it) and stop the recording. Excel will pretty much make the VBA for you. Just assign that code to a new button and you're good to go.

[@harrylew8064]

@@IntegratedSchoolForms that's an ingenious way, thanks :)

[@IntegratedSchoolForms]

@@harrylew8064 great to help

[@tindencen]

What causes Run Time Error 400?

[@IntegratedSchoolForms]

you can check the specific line in the macro window that might cause this error. there are many possible causes. better double check the codes too.

[@tindencen]

@@IntegratedSchoolForms Done it...thank you.... can you very much sir...

[@IntegratedSchoolForms]

@@tindencen great to help

[@TheRevlation]

I dont know when was this made... but he made a simple task complicated. Just do this: Select the whole range you want Filtered. Go to DATA>Filter... or press Ctrl+Shift+L Then filter according to your needs.... no formulas needed

[@IntegratedSchoolForms]

Yes, that may be true. The purpose of the video is to show everyone how to use the VBA codes we are utilizing in the different automated templates we created. This option is universal which does not rely on the restrictions of DATA FILTER option on merged cells. As demonstrated, we are referencing the cells based on their actual cell name which can be extended in a multiple array of applications. With this method, an approach on referencing towards merged cells may not be a problem. Further, this option also allows the user to use buttons which can be activate the VBA with just 1-click instead of multiple clicks in a Filter Option.

[@CapitanChoripan]

Thank you random commenter on KZbin!

[@ovakem]

You could simply multiply column1 * Column 2 and the result would be Zero if any of the columns were Zero, no need to write the "or" formula.

[@IntegratedSchoolForms]

yes, that would have been easier but the values were not treated as integers but as text and the formula was presented in order for the viewers to understand that the values 1 and 0 can also be "yes" or "no"; or "true" or "false"; whichever they would prefer. In such a case, the multiplication formula would not work.

[@georgegonos760]

You do a good job but spend too much time off subject. I am now at 9 minutes of the 13 in the video and you still have not told me how to auto-hide the rows. Instead, you spent well over half of the video teaching other things.....come on man! And, what's up with the annoying background music bro?

[@IntegratedSchoolForms]

hey man, appreciate the comment.... you know most of my tutorials are for beginner excel users and hoping that by showing it step-by-step, they won't have any issues when running the process in their own. as for the music,lol, sorry man, i like that background music man... it kinda' keeps me up.. but sorry if you found that annoying.

[@aajayi]

Very poor explanation 😢

[@IntegratedSchoolForms]

Which part?

[@aajayi]

Actually I’ve re-watched the video and it’s not that bad, however, the video is a bit too long and people will loose concentration. The first 6 minutes was good but the last few minutes could have been simpler and more straightforward perhaps. In anycase I’ve given you thumbs up 👍🏾

[@iainhmunro]

@@aajayi If you are going to comment, you better be 100% yourself - like your spelling - Loose ?

[@aajayi]

@@iainhmunro no idea what ur talking about 🤔