Copy Paste and Delete a cell based on condition

[ipon70]

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 down to E18 with each row corresponding to its own row...ie(E4,H4,F4 and E5,H5,F5) and so on.

Any help would be awesome as I have spent entirely to much time on this project already.

Thanks in advance.

 

[footoo]

Post some sample data.

 

[footoo]

Check why your formula is returning #N/A

 

[ipon70]

When I put the data in is when the date appeared in H4, and then the F4 changed to NA

 

[footoo]

It works for me and can't see anything in the code that should affect the formula in H4.
Perhaps someone else has some ideas.

Check the formula before running the code, and check it afterwards.
What has changed to be making it return N/A ?