Can a Command Button's position be kept moving along the TargetCell ROW in the same Column

Dear Dave,

It did work but it creates a circular reference as the entire cell gets copied alongwith the formula for the Maturity Amount which becomes the Principal AMount when the button is clicked..so can you please suggest a slight modification for that as well as how do I maintain the formatting in the columns since there are some columns which change places and therefore the formatting changes as the original while i need to maintain the same formatting like the column has..

It works and I agree to it and your help was indeed valuable as well as the links you provided are also very helpful...but I just need to better it..

Lets say i have data only till the 11th row i.e 10 records excluding the column headings so naturally my formulas in the columns A and the column K and COlumn L are also till the 11th Row..

Is there some method wherein I can have these formulas also get copied when I run the command button click..
I need help on these areas so that this work would be completely air-tight.

I want the Data Vaildation in the columns B and Columns C alongwith the Formula in the col A for Sr.No and the formula in the col K for the Maturity Amount as well as the Formula in the column L for the Interest to get written when the data gets copied to the last row..

I would appreciate if you could just help me with just 1 Data Validation and 1 Formula and I will take a cue from there.

Bottomline is I need help on some formatting and the Formulas..

Thanks in advance..

Warm Regars
e4excel