Hi All,
Here is what I am trying to do. I have a formula in cell E9 in tab TOTAL FINANCIALS. This formula is an IF statement that will result in either 36, 48, 60, or 72 based on what a user selects in a drop down box (cell C11) and a date (cell C9) in a separate tab called FINANCIALS. (I already have script in “financials” tab to hide columns and I want these same columns hidden in “total financials tab”).
If the formula in E9 results in:
36: hide columns F, G, H
48: hide columns G, H
60: hide column H
72: hide no columns
The problem I am having is I basically want the exact same columns hidden in an additional tab but it will not be the “active sheet” I am working in. Any help would be greatly appreciated.
Here is what I am trying to do. I have a formula in cell E9 in tab TOTAL FINANCIALS. This formula is an IF statement that will result in either 36, 48, 60, or 72 based on what a user selects in a drop down box (cell C11) and a date (cell C9) in a separate tab called FINANCIALS. (I already have script in “financials” tab to hide columns and I want these same columns hidden in “total financials tab”).
If the formula in E9 results in:
36: hide columns F, G, H
48: hide columns G, H
60: hide column H
72: hide no columns
The problem I am having is I basically want the exact same columns hidden in an additional tab but it will not be the “active sheet” I am working in. Any help would be greatly appreciated.