Auto Populate Form & Hyperlink

Hi

It works. However, short of 1 instalment. For eg. if last payment for Contract 5 is on 16 Mar 15, the form only show till 16 Feb 15.

Please assist.

Thank you.

Try this modified formula in B11 of Form sheet and fill down.

Formula:

=IF(DATE(YEAR($B$10),MONTH($B$10)+ROWS($1:1)-1,DAY($B$10))<INDEX(Data1!$D$4:$D$8,MATCH(Form!$F$3,Data1!$A$4:$A$8,0)),DATE(YEAR($B$10),MONTH($B$10)+ROWS($1:1),DAY($B$10)-1),"")

Fantastic! Thank you.

You're welcome. Glad it works and thanks for the rep.

(and thank you for marking this thread [SOLVED].)