I have my code set up exactly like the video and I keep getting Run Time Error '91' Object variable not set. I've tried everything I can think of but it won't work. The Set FindHdg1 = Cells.Find("Heading Name") says that it is = to nothing for some reason. Someone Please Help!
I have sheet I'm working on and I'm using your method which works great for one column, but what do I do if I have multiple columns I want to show with the same heading while hiding others? Eg I have 3 columns named Test 1, 2 columns named Test 2, and 4 columns named Test 3. When I pick Test 1 from my dropdown, it only shows the first instance of Test 1 and hides the other 2 with all the other columns.
Believe I'm running into the same issue you describe, only with Rows. I have multiple categorized data sets that all will include my validated Test. When running the validation, all rows beyond the first data set are hidden instead of keeping each data set. That's where I'm stuck.
Thanks for the great tutorial. When I get to the part of the code where I have to add a case for each option in my drop-down list, how do I reference just the cell reference and not the actual text (my drop-down list refers to a named range which has variable values - so how do I reference only the actual cell when adding a case (ie Case Is = "Data!A!" etc
Hai… I need a help. I have 10 rows and row wise I have name and I have 7 technologies name as column heading. Those name who knows the technology will mark as Yes and others as No in the cells and blanks also. So if I select the names of technology on a drop-down and yes or No on another drop down I want to get all the names who knows the selected technology. How can I do it
suppose i have a data set from col a to f. In column d i want to have a dropdown option (Show,Hide). if i select hide , i want to hide column e and f for that respective row only. Any way to do that??? **some kind of preview function im looking for based on dropdown**
You're out here saving lives and jobs! THANK YOU!
Excellent explanation Chester. A great code. Thank you for the VBA macro.
Thanks a lot for the vba code, it helped me a lot in completing my requirement.
Another excellent lesson Chester - thank you so much I can use this for various sheets I am working on.
I have my code set up exactly like the video and I keep getting Run Time Error '91' Object variable not set. I've tried everything I can think of but it won't work. The Set FindHdg1 = Cells.Find("Heading Name") says that it is = to nothing for some reason. Someone Please Help!
Thank you for this explanation, may I know how to hide multiple columns based on the dropdown cell value?
How would you hide/show columns data based on a search box, instead of a drop down. The data is not made as a table
Hi, thanks for the video, what if we dont want to use heading? Just numerous tables.
Thanks
Fantastic lesson. What if I want to hide specific rows (i.e., rows 37-40 for "Cash")?
Did you ever get this one figured out? I am stuck at exactly the same spot!
Useful lesson
Hi! Can we do this on google sheets?
I have sheet I'm working on and I'm using your method which works great for one column, but what do I do if I have multiple columns I want to show with the same heading while hiding others? Eg I have 3 columns named Test 1, 2 columns named Test 2, and 4 columns named Test 3. When I pick Test 1 from my dropdown, it only shows the first instance of Test 1 and hides the other 2 with all the other columns.
Believe I'm running into the same issue you describe, only with Rows. I have multiple categorized data sets that all will include my validated Test. When running the validation, all rows beyond the first data set are hidden instead of keeping each data set. That's where I'm stuck.
Thanks for the great tutorial. When I get to the part of the code where I have to add a case for each option in my drop-down list, how do I reference just the cell reference and not the actual text (my drop-down list refers to a named range which has variable values - so how do I reference only the actual cell when adding a case (ie Case Is = "Data!A!" etc
Hai… I need a help. I have 10 rows and row wise I have name and I have 7 technologies name as column heading. Those name who knows the technology will mark as Yes and others as No in the cells and blanks also. So if I select the names of technology on a drop-down and yes or No on another drop down I want to get all the names who knows the selected technology. How can I do it
suppose i have a data set from col a to f. In column d i want to have a dropdown option (Show,Hide). if i select hide , i want to hide column e and f for that respective row only. Any way to do that??? **some kind of preview function im looking for based on dropdown**
hello can we do this on google sheets?
Calling this fantastic doesnt even start to properly describe it.
I HAVE DOWNLOADED, THE FILE WAS OK AT THE BEGINNING, NOW IT'S NOT GOING, IS IT FORMULA DEMO? CAN YOU REMOVE ME FROM DOUBTS