Auto Populate Form & Hyperlink

Hi

I need assistance
1) I have worksheet (form) which I want to print for hard copy records. How to autopopulate the dates based on the number of instalments.
2) I have created a hyperlink to link the worksheet, is there a way, using excel formula, that the cursor will go the the last cell when we click the link.

Thank you.
Nancy