On one sheet (“Enter Info”) I have three sections of named ranges of
names (A_Names, B_Names, and C_Names) and each name within each range
has a date associated with it. These dates are also clumped in
respective named ranges (A_Dates, B_Dates, and C_Dates) as so:

(A_Names) (A_Dates)
Brad ......... 12 NOV 05
Tom ......... 15 DEC 05
Dave ........ 28 JAN 06

(B_Names) (B_Dates)
Chad ........ 3 MAR 06
Tim .......... 7 DEC 05
Steve ........ 13 AUG 06

(C_Names) (C_Dates)
Jill ............ 8 FEB 06
Beth ......... 22 NOV 05
Greg ......... 2 DEC 05

What I would like to have happen is that, upon comparison with today’s
date (an actual updating today’s date), if a person’s associated date
within any of the three original named sections is after today’s date,
I want it to be stored in an array and displayed on another sheet
(“Output Data”) within a named range of cells (“Output_Names”). As time
progresses, the name should be removed since it no longer fills the
after today’s date requirement.

I’m not sure about the whole array thing (do I need one for something
like this) or can I simply have code run that will input the names
matching the condition onto a sheet? An example output for today's date
(8 DEC 05) would be:

(Output_Names)
Tom
Dave
Chad
Steve
Jill


--
BrianDP1977
------------------------------------------------------------------------
BrianDP1977's Profile: http://www.excelforum.com/member.php...o&userid=29110
View this thread: http://www.excelforum.com/showthread...hreadid=492041