Thread: Possible?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Stephenson Mark Stephenson is offline
external usenet poster
 
Posts: 3
Default 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.