Hi,

I dont know a great deal of VBA, so dont know if this is possible...

I have a spreadsheet with 2 sheets, One is a kind of contents page, the
other is a notes field.

Sheet1 - TOC

Task Description
A Blah Blah
B More Blah Blah

Sheet2 - Notes

Task Detail
A This and That
A That and This
B Not that

What I am wanting to do is to be able to click the cell in sheet 1 that
contains a task letter and this set the autofilter to filter on the clicked
cells value.

Is this possible??

Many thanks,


Mark.