Hello,
New member and first time post. Intermediate Excel user, complete VBA novice.
Goal:
I have a workbook that has several sheets. In sheet1, there are inputs that determine whether Column A in other Sheets has a 0 or 1 in it. I need a VBA code that will autohide the each row that Column A has a 0 in. Autofilter would work fine except this workbook will be used frequently and the cells in column A will change from 1 to 0 and back, and I can't get Autofilter to be dynamic as needed. (once hidden, if the hidden cell changes back to a 1, it doesn't automatically unhide). Can I get the VBA code to work for the entire workbook? Or would I need to insert it into each Sheet's respective VBA input?
Other Details:
Column A isn't very long with 80 cells or so being referenced (usually no more than 30 rows would need to be hidden).
Sheets2,3,n...'s Column A is based on inputs from Sheet1 which is formula driven (if that matters)
I have attached a work-in-progress workbook that this code will be used in. All data is ficticious. 3.0 with VBA.xlsm
Thank you very much for your time. I have searched several forums and have tried to copy/paste several different codes, but have not had any success. (some of the code froze my workbook altogether).
I will be monitoring this thread like a hawk, if you need any additional detail, just ask.
Thanks again,
Shawn
Bookmarks