I am very green at excel but am learning fast. I work for a car dealership that is starting abuy here pay here option.
I have made a loan calculator that shows weekly, bi-weekly and monthly payments. Works great. 2nd work sheet
gets it's info from the first page which also works well. 3rd page is where I would like to have the printable payment
coupons. I have made 1 coupon on page 3 that gets it's info from the other pages and that works well but can't seem
to copy it to the 2nd coupon with out putting in the formulas again. which I could do but if you pay weekly thats like
52 payment coupons just for 1 year little own a 3 year loan that I would have to enter for every coupon. Here is my question.
Is there any way to make 1 and copy it 52 times and have it have the correct formulas but in return say coupon 1, 2, 3 and so on.
Want it to look like a payment book from the bank that has like jan 18 2012 on the coupon and feb 18th 2012 on 2nd coupon
and so on. Don't know if I'm making any sense. Like I said i'm very green. Watched alot of youtube videos and have to say excel
is amazing and alot of fun. Could really use some help. Tried finding a template but no luck. Thanks for any help you might have.