I have read lots of threads on how to create Dynamic Ranges. I also know I
can use it to automatically update a chart or do some simple calculations.
But I am still struggling to do the following:

Suppose I have Column A as a dynamic range called "Date", Column B called
"Rate" in the tab "Input". I can type in date and interest rate each day
manually and I know the ranges will automatically expand. However, I want to
do calculations in another Tab "Cal", such as dividing the interests by 12 to
get monthly rate in column A, then Imultipling it with a constant say $1,000.
My question is, is it possible to have Excel automatically add rows in tab
"Cal" and do the calculations whenever a new row in Tab "Input" is added?

"Input" Tab

A B
(Date) (Rate)
1 1/1 5.5%
2. 1/2 6.0%
3. 1/3 6.2%

"Cal" Tab

A B
MthlyRate Times 1,000
1 0.458% $4.58
2 0.500% $5.00
3 0.517% $5.17

(Can calculations in Cal Tab be populated once the dynamic ranges in Input
Tab expands?)

THANKS!