Download the file below:
Select the cell containing the word "Wife".
Now select the cell beneath it.
you should see that it selects Britney in cell B4.
Now amend your macro so that it selects all of the brides (no matter how many there might be) using the END keyword:
Finally, amend your macro so that it selects all of the marriage data (from Britney down and across):
Answer: