Possible?
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.
|