Well its possible but still unclear -

How does data get into E2
what data is it - does it need to be preserverd, is there a formula or
validation to worry about?


"Dan Wood" wrote:

That works to clear the entire column, but isn't quite what i need.

The sheet is to store passwords, then there is a macro to add appointments
into outlook for the date the password needs changing. Therefore, in column
'A' starting at row 9 there is a list of system names. Then in column 'D'
starting in row 9 again is the date that the password expires, and this is
added to the calendar. Column 'E' is simply there as a way to stop duplicate
entries in the calendar. So what i want is for example if the system in A12
password expires, it will then be changed and the new expiration date will be
input into D12, so i only want E12 to be cleared.

Is there some way to do this, or is it to complicated?

Thanks for your help