Anyone know how I can filter a list by a variable in a list and have cell A2
always show the latest variable the list is filtered by. The list would start
on say Row 4 so e.g Heading is Product, this column filtered to show the word
Health. I want this to automatically also appear in Cell A2. using Excel 2003.

Thanks in advance.