E
Exceluser
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!
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!