I am creating a spreadsheet for a future wedding and populating Sheet1 with names (Column A), RSVPs (Column B), and Column C as dropdown menus with options "Yes" or "No" if the person needs a room booked for them.

In my Sheet2 I want to populate Column A with the names of the people, and Column B with the # of people they RSVP'd if the chose the option of "Yes" in Sheet1 for needing a room booked So I can keep track of who needs rooms booked and for how many people.