Hi everyone,

If soemone could assist with this I would be most grateful.

Bobs reply works fine, I just need to make it automatic, for instance,
each time the worksheet is recalculated or immediatley I enter a ne
leave date on the leave sheet.

Hoping someone can assist.

cheers
Koal

--
Message posted from http://www.ExcelForum.com