I am working on a workbook (Excel 2007) where one sheet shows a kind of chronological chart ("ChronologicalChart"), featuring names of various painters, and another sheet is a "TableOfPaintings", which details the various paintings by each of the painters featured in the chart. While viewing the "Chart", I'd like to be able to click on the cells with the names and be automatically taken to the "table", and have excel/vba apply the filter to column A, where I list the painters' names. (The strings in column A of the "Table" match the string of the cell I click on in the "chart").

I know how to click on a cell and be taken to some other cell on some other sheet. But I am struggling to figure out how to automatically apply the filter, so that I am looking at the table with nothing other than the works by the painter I clicked on.