Thank You all for the help..one more question..for now
 

Hi All.

Thank you all very much for all your help and suggestion. My incident is
now in placed and all key staff are entering the appropriate info on a
daily basis.
I just have one more feature which I would like to add to this spreadsheet.
Is it possible to protect data that are seven days or older so they cannot
be altered anymore after the period expired while new data can still be
entered?

Thanking you all for your help.

SLO

Thank You all for the help..one more question..for now
 

Is it possible to protect data that are seven days or older so they cannot
be altered anymore after the period expired while new data can still be
entered?

if (Date-DateCell.Value)6 then
DateCell.Locked=True
end if

Remember idiotic Excel behaviour: to protect cells you need to set
Sheet protection (with empty password to activate cells protection
only)