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.
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.
Last edited: