Hello everyone,
I am new to excel VBA and hoping someone can help with a problem i have run into. My worksheet called "Data" has a cell that changes (A5) projects and based on that change I used index functions to pull multiple rows of data from another sheet. I have set up basically a range of rows (A5:U20) that these will fit in, but the problem is some projects have more rows than others, and I would like to automatically hide/unhide rows based on if they are blank or not. If more info is needed, let me know. Thanks
I am new to excel VBA and hoping someone can help with a problem i have run into. My worksheet called "Data" has a cell that changes (A5) projects and based on that change I used index functions to pull multiple rows of data from another sheet. I have set up basically a range of rows (A5:U20) that these will fit in, but the problem is some projects have more rows than others, and I would like to automatically hide/unhide rows based on if they are blank or not. If more info is needed, let me know. Thanks