Is it possible to select criteria from an autofilter but from
different worksheet. Can dropdown arrows be linked or copied via
macro?

Ton

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

Hi
AFAIK you can't link an autofilter to a different sheet.
For your second question I'm not sure what you want to
copy?

-----Original Message-----
Is it possible to select criteria from an autofilter but
from a
different worksheet. Can dropdown arrows be linked or
copied via a
macro?

Tony


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

.

Hi Frank

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

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

Tony
:confused

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

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/

Forgive my ignorance, but how would I change the event in the sheet?

Ton

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

http://www.cpearson.com/excel/events.htm
on Chip Pearson's site

has an introduction to Events

You aren't changing the event - the event is fired when a user changes the
value in the worksheet (edits a cell). You put code in the event to check
if it is a cell you are interested in, then if it is, you would use the
value placed there to do your work, such as set the criteria for an
autofilter on another sheet.

--
Regards,
Tom Ogilvy


"TONYC " wrote in message
...
Forgive my ignorance, but how would I change the event in the sheet?

Tony


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

Perhaps what you need is to write the VBA code to generate the list of unique
items that you see in the AutoFilter dropdown (and sort it).

On Tue, 3 Aug 2004 06:48:41 -0500, TONYC
wrote:

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/