Here is my dilemma.
E4 contains nothing until it says "100"
H4 contains a date found on another sheet, that updates daily.
F4 needs to contain the date from H4 when E4 says 100, but once F4 contains that date, never check or copy or update that date again.
That will then need to repeat from E4...