I'm having a lot of trouble trying to figure this out.
This is my layout:
As you can see, I have 2 buttons.
What I would like each button to do is:
- Each time I click
YES
, it will insert aY
in a cell in a specific range. - If I click
YES
again, it will automatically insert aY
in the next cell under the previous one in the same column. - If I click
NO
, it will also continue down the column and insert anN
.
How to make the buttons' output to always use the next free cell?