Is it possible to use a macro to duplicate the action of autofilter.
For example I have a name in cells A1 & A2 of worksheet 1 and want t
pull out all instances of those two names (if they appear together
from worksheet 2 and display them in a third shee

--
trye
-----------------------------------------------------------------------
tryer's Profile: http://www.excelforum.com/member.php...fo&userid=1654
View this thread: http://www.excelforum.com/showthread.php?threadid=39266

Try recording a macro when you do the filter. And even continue recording when
you copy the visible cells to the other sheet.

Then turn off the macro recorder and look at the code.

tryer wrote:

Is it possible to use a macro to duplicate the action of autofilter.
For example I have a name in cells A1 & A2 of worksheet 1 and want to
pull out all instances of those two names (if they appear together)
from worksheet 2 and display them in a third sheet

--
tryer
------------------------------------------------------------------------
tryer's Profile: http://www.excelforum.com/member.php...o&userid=16546
View this thread: http://www.excelforum.com/showthread...hreadid=392665

--

Dave Peterson