Macro to fill in cells from a column sequentially when I click on a button

[Mary_z]

Hello.
I'm have 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:
1. Each time I click on YES, it will insert a Y in a cell in a specific range.
2. If I click on YES again, it will automatically insert a Y in the next cell under the previous one in the same column.
3. As you can see, if I have to click on NO, it will also continue down the column and insert an N.


If someone can help me out with this I'd be very grateful!

 

[Smitty]

Welcome to the Board!

I don't know why you are the "cross post" police or anything.

No one's the "Cross Post Police" here, believe me.

It's just helpful to others to see what you've posted, and what others might have done for you so there's no duplication of effort in different places.

See: Excelguru Help Site - A message to forum cross posters

And again, Welcome to the Board!