0
I have "sheet2" in which data populates dependent upon what's entered into "sheet1". The data populated is either "N/A" or a particular statement.
In sheet2 I'd like any rows with "N/A" in Column G to auto hide and become unhidden if data in sheet1 is changed resulting in a change from "N/A".
I know VBA is probably my answer, but I have no knowledge/experience working with those.
1Since you already an excel sheet with formulas.. mind sharing a sample file or data+formula in Sheet1&2 for a clearer view. || "Column G to auto hide and become unhidden" <--- IMHO select header > data > filter will work automatically without vba/formula.. but it only hides rows, not columns. – p._phidot_ – 2018-08-11T19:23:41.213
Can't share due to proprietary reasons, but I'll do my best to explain.
Sheet 1 "Heading" is a questionnaire. I have the check boxes linked to a cell to indicate TRUE or FALSE if selected or not. Sheet 2 pulls data from Sheet 3, "Narrative" depending on what is selected in Sheet 1 (TRUE or FALSE).
Example formula:
=IF(OR(Headings!B6=TRUE,Headings!B7=TRUE,Headings!B10=TRUE,Headings!B11=TRUE),Narrative!C29,"N/A")
N/A populates quite a bit, and in stead of a full row of "N/A's", I'd like those rows to hide until they show something else. – user932858 – 2018-08-11T19:35:27.177
So this is the formula contained in column G Sheet2.. right? – p._phidot_ – 2018-08-11T19:37:20.837
Yes. I figured I'd have to make a new Column G and put a formula like =h1 (h is old columng ) so it shows N/A or whatever and use that in the VBA. – user932858 – 2018-08-11T19:40:33.870