Consider the attached example Reference data in autofilter.ods
Is there a way for cell A1 to display “Data belonging to Acme” or “Data belonging to MGM” depending on which filter I have active in the autofilter?
FYI, the end result is that every month I will have a table like this, and then I need to export and print one sheet per client. Best solution I found so far is to filter by client, then export a PDF of it.