I apologise for my imprecise wording in #7.
I used the term "Delete all entries that do not involve Jasmine [that leaves rows 11 and 12]."
More precisely ...
"Clear the entries in cells in column AF that do not involve Jasmine"
The formulae in columns AG to AO will automatically determine what rows need to be displayed in the report - including relevant headings.
Filter column AO for "Yes" to create the final report
Example - refer to the worksheet attached to #7.
In #1 I asked....
Is there a solution without using VBA?
The volunteers in the non-profit organisations that use my Excel contributions have only basic to medium competency in Excel.
If I use VBA and MS ceases to support a VBA command [that has happened a few times] and I am no longer around to help, there is a problem.
There are not a lot of VBA-experienced volunteers around to fix it.