How to Reference the value of the filter in autofilter?

asked 2019-04-29 17:16:12 +0200

migueldealmeida gravatar image

updated 2019-04-29 18:21:01 +0200

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.

edit retag flag offensive close merge delete


Are you sure you need to export the filtered data as a sheet per client? Why shouldn't it be sufficient to create and to print the filtered selection of data as a report per client? That should be the way things of this kind are commonly done.
Anyway you might consider to move the task to a database.

Lupp gravatar imageLupp ( 2019-04-29 19:00:18 +0200 )edit

Filter the table+printing is sufficient, yes. However, I would need the first row to display the "data belonging to...", which is what I was hoping to be able to retrieve from the filter (or the first visible row after applying the filter) automatically.

migueldealmeida gravatar imagemigueldealmeida ( 2019-04-30 10:06:40 +0200 )edit