I would just use the Data Filter AutoFilter feature and select Custom
from the date column and enter "greater than" 0
It will filter all those with a name and a date..........
To return to normal, just do Data Filter Sutofilter again.....it's a
toggle
Vaya con Dios,
Chuck, CABGx3
"Sam Crump" wrote:
I have a list of contacts in a named range. In another named ranged i
have the date if one of the contacts has returned a questionnai
Name Questionnaire Returned?
Joe Bloggs 02/02/06
Alan Simple
Billy Carntdo excel
Miffy The Cat 01/03/06
On a seperate sheet I'd like a list (without spaces) of all those who
havent returned their survey yet (i.e. Alan S and Billy Carntdo above).
I'd like this list to update as I enter dates for survey returns.
Is their anyway of doing this, I have been fiddling with CSE formulas
and named range intercepts all morning please help!
--
Sam Crump
------------------------------------------------------------------------
Sam Crump's Profile: http://www.excelforum.com/member.php...o&userid=32184
View this thread: http://www.excelforum.com/showthread...hreadid=519343