1 of 1 people found this helpful
If the BU Level 2 field is somewhere on each worksheet, then it will be able to be added to the Title (use the Insert button on the Edit Title dialogue). Then, depending what is selected in the filter will appear in the title. I'm not sure if this is what you're looking for, but I hope it helps!
Thanks Tracy, it worked. I had to put an Index formula as one of the filters.
When I select a value in the filters, the title change in the respective worksheet, however all the other titles changed to "Null". Would you know how to set the titles of the other tables so that if the option is selected in the filter, they will become blank?
I'm glad it worked! To get the titles to show blank, you could possibly created calculated fields and put it on each worksheets?
If [BU Level 2]='City A' then 'City A' else ' ' end
I think a calculated field would need to be created for each worksheet. I think this should work, I hope it does!