Try this page on the Debra Dalgleish site

http://www.contextures.com/xlautofilter03.html

Tom Ogilvily has writeen a macro to copy filtered data onto anoth sheet.

Regards
Peter
"aaghd" wrote:

Thanks, I was looking through some other threads (in particular - a thread
from Mick - subject: Listing data based on a referneced criteria - dated
12/9/2006 3:09 PM PST) and figured that I can probably use the Index and the
Match functions but for the life of me, even after reading the help topics
and reviewing their example, I am not sure of how to write a formula for my
particular situation.

Was hoping that one of you Excel/Math wizards could throw one together for me.

--
aaghd


"Teethless mama" wrote:

Look in Help menu for INDEX and MATCH Functions

"aaghd" wrote:

I need to pull rows from a List where a date value is less than the first day
of the month and have the rows that do not meet the specific date copied to
another sheet.

Example of my data: (Criteria = Column H, where date is <12/1/2006)

Sheet 1
A B C D E F G
H
Row 1 RH MDA 057202 Text 1 X 10,000 2.00% 10/10/2006
Row 2 MF OPCO 008702 Text 2 X 42,000 3.10% 12/11/2006

Sheet 2
Row 1 RH MDA 057202 Text 1 X 10,000 2.00% 10/10/2006

Row 1 would be copied from Sheet 1 and duplicated on Sheet 2 because the
date in Column H is less than 12/1/2006 (I would make the date criteria a
Named Range).

If possible, ideally just Columns A, B, C, D, E and H would be copied
instead of the entire row of information.

If it was possible to Advance Filter to another sheet - this wouldn't be a
challenge!

I appreciate your assistance.

Thank you,

--
aaghd