You can't link them, but you can use the change event in the sheet where the
selection is made, and update the criteria in the autofilter within that
event.

--
Regards,
Tom Ogilvy

"TONYC " wrote in message
...
Hi Frank

It is really the same question. I was intending to have a menu
worksheet with dropdown arrows which slected from autofilter in a
different sheet.

As it is not possible, I will have to re think.

Tony



---
Message posted from http://www.ExcelForum.com/