Having a title appear based on filters

I have a 6 column spreadsheet that will almost exclusively be filtered by two different columns.

Assuming I filter them in specific ways (i.e. 2011 is one column, >=640 in the other as an example), is there a way to make a specific heading pop up in Excel for a pre-defined combination of filters?

(i.e. if I set up the two above filters, a cell would read "2011 Customers Aged +640 Days", and then would say something else if I filtered 2010 & >=640 or 2011 <=640)

No, not necessarily. I have the first row of cells merged into one cell, that has a generic title on it.

I was wondering if it's possible to have that one cell change it's contents based on how the columns beneath it are filtered.

Oh, actually, just reread what you asked, and yes. I do want them to replace the text when changed, just not necessarily in the same column.

Here we go. I had to cleanse it of the relevant information. You'll see a lot of the fields are blank... that's more or less for "public" purposes.

The top cell that currently reads "Customer Credit App. Form Tracking Sheet" is what I'd like to see change based on the filtering.

For an example, let's say I filter column E by removing the "Inactive" and then filter column M to be an or statement of ">=640" or "None Signed". When I do those two together, it would pop up in the top cell as "Customers needing a new application."

Consequently if I filtered column E removing the "Inactive" and then filter column M to be an or statement of "<640" or "No T&C Required", then it would say "Customers with current credit application information".

It's been a while so it's worth a bump...

Is this something that even can be done without 100 pounds of horrid programming? If so, that's fine, I just want to know how plausible it would be to do.