I am using version 2019b.
Using if(col(A)==0, 0, 1) will not work for what I need. The example I provided is only the start. I need to make it work first.
if (Col(H)==0)
{
x=0;
<write row values to different sheet in next open row of col(A)>
}
Else
{
x=1;
<write rest of script based on x=1>
}
<provide new value for x to use in cell>