Complicated Problem!
 

Hi All,

In A1 I have a date (this date will always be changing), let's say 01/01/05.
In column B I will have a long list of dates. I would like excel to remove
all the dates in column B if they are less than A1. Is this possible?

Cheers

SPL

Complicated Problem!
 

A couple of suggestions
1) use conditional formatting to 'hide' old dates by formatting them with
font colour same as background
2) use a 'helper column' with =IF(B1<$A$1,1,0) in B1 and copied down the
column; convert to values (Copy followed by Paste Special); sort by helper
column and delete the 'tail'. All this could be recorded as a subroutine.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PH NEWS" wrote in message
...
Hi All,

In A1 I have a date (this date will always be changing), let's say
01/01/05.
In column B I will have a long list of dates. I would like excel to remove
all the dates in column B if they are less than A1. Is this possible?

Cheers

SPL