Here is what my excel table looks like
A B C D E F G K L M N
1 2012 2013 2014 2015 2016 2017 2018 Maturity 2016 Today's Year 2013
2 1% 3% 3.5% 2.1% 5.6% 4.3% 3.4%
I have about 15 series of rows with different numbers that go from 2012 to 2018. I would like to calculate the average for each row from today's year to maturity. In this case the average of numbers would go from B2 to E2. The maturity sometimes changes and well as today's year. I am new to VBA programming and I am trying to learn by doing. The books just do not help me.