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