Hey All. I'm a new poster here and thank everyone ahead of time for their help.

So I am working on a financial document in excel which involves rentals. Basically, these are multi-year rentals which on the anniversary of the contract signing increase by 4% or 5% annually. That means, if I rent it out on March 1st 2007 for 1000$, it will be $1050 from March 1st 2008 and then 5% increase off that number in 2009 etc. What I want to know is it possible to have Excel update my spreadsheet depending on the calendar automatically. Is there any kind of Macro program? I have over 600 rents, that is why I want the process automated. I would want the rents to increase on the anniversary of the contract signing every year and so basically the Excel would update itself, or it would update once I turn it on and then run the macro. Is this possible?

Next question I have is, say I scroll my mouse over the rent column. I look at building A and look at the rent for this year. Is it possible that once I pop my mouse over it a small chart can pop up and describe the rents for the previous years. Meaning a chart that would quickly pop up and show the 5% decrease every year for the past say 5 years.

I am simply trying to organize my corporate finances and this would be a great help.