Hello, I am currently writing a table to enter values. A1:C11. The table has entries of a numerical value between 1 and 3. I would like a macro that, if the value n is entered in Cell A11, then all the other cells on that row change to 1 automatically. IE A1 through to A10. This would also operate for each independent row.
Thanks in advance.