keeping columns hidden


I have three sheets A, B, and C where an automation copies a row from A to B or A to C when certain conditions are met. Sheet A has three columns, "occupation 1," "occupation 2," "occupation 3" where only one value is present in one of the three cells. I have a formula that copies the value from the cell that is not blank to a column labeled "occupation." Sheets B and C have all three, 1-3, occupation columns but two are hidden in each sheet. leaving only one visible. If a row is copied and has data in one of the hidden cells, the column unhides itself. Is there a way to keep it hidden?


Best Answer