I am trying to create two buttons that, when either is selected, will run a
macro to populate all fields in that column with a "Yes" or "No" depending on
what button they clicked on. Let's say the "Yes" button is placed in cell
A1, and, if selected, all fields from A2 on have "Yes" inputted. I would
also like the macro to look at Column B. If the contents of cell B2 are
blank, then A2 would remain blank. If cell B3 has something in it, then A3
would populate with a "Yes" after the "Yes" button is selected.

I know how to create the buttons, but I am having trouble completing the
macro. Any help you could provide would be greatly appreciated. Thanks!