Spreedsheet's object script
I have an object in A1, and the script OnClick B1 = If [B1 == 0,1,0]. I would like to have a similar relationship between A2 and B2, A3 and B3, etc.
In total, it is always a few dozen objects. Copy the script is very labor intensive. Is there a faster way?
Thanks for your help.