useform

[rakesh seebaruth]

Hi Guys

I have the following userform in the here under link

https://www.dropbox.com/s/y7lstauovd3iojd/5.xlsm?dl=0

I need to do the following :-

when the user enters Name in the text box same shall replicate in Name1 and Name3 3.Example if the user enters John Smith , John Smith shall appear in Name1 and Name3.

Same applies for Agreement Ref and Client Ref.

If Lease Period is 60 then insert 60 cells after heading installment in sheet1 and name the heading as month1 to month60.Please note that the Lease Period may vary.For example it can be 60,84,90.

If Installement for example is 25,000 then fills month1 to month accordingly.

Your help will be highly appreciated

Thanks/regards

rakesh