IF condition is true, copy a value to multiple cells
I have a sheet where users have to fill in 20 columns with numeric data. In some cases the data will be exactly the same for all 20 columns. In that case, I want to give them the option to select a dropdown that says all values are the same, and then use a helper column that triggers from that to copy the value from cell 1 of 20 to the other 19. I can't put a formula in the other 19 cells because the user may be overwriting it with manual data entry.
Is there a function that would allow me to copy the contents of cell 1 to the other 19 cells?
Help Article Resources
Check out the Formula Handbook template!