S
Set_0ne
I need to do something at work in MS Excel, but I'm not sure how to d
it. I was wondering if anyone reading this is good with Excel and migh
be able to help?
Ok, here's the dealie. I need to create a spreadsheet of all ou
tenants and have data be put it and displayed the following way:
Amongst other info, there will be a part that lists monthly rent
another will show the percentage the rent increases every year (if a
all), and another showing the anniversary of their renewal as a month
What I want to do is this:
Create a Jan-Dec list that shows rent per month, and on the anniversar
month will show the increase, and have it automatically decide whic
month gets the increase. This will come out kinda like:
Tenant | Rent | % Increase | Anniversary .... Jan Feb Mar Apr May Ju
Jul Aug Sep Oct Nov Dec
(Where Jan-Dec lists the rent for each month)
And if the increase is on, say, Jul that Jul-Dec will show th
increased rent amount.
Ok, phew. So ok, can any of you help? Thank you in advance!
it. I was wondering if anyone reading this is good with Excel and migh
be able to help?
Ok, here's the dealie. I need to create a spreadsheet of all ou
tenants and have data be put it and displayed the following way:
Amongst other info, there will be a part that lists monthly rent
another will show the percentage the rent increases every year (if a
all), and another showing the anniversary of their renewal as a month
What I want to do is this:
Create a Jan-Dec list that shows rent per month, and on the anniversar
month will show the increase, and have it automatically decide whic
month gets the increase. This will come out kinda like:
Tenant | Rent | % Increase | Anniversary .... Jan Feb Mar Apr May Ju
Jul Aug Sep Oct Nov Dec
(Where Jan-Dec lists the rent for each month)
And if the increase is on, say, Jul that Jul-Dec will show th
increased rent amount.
Ok, phew. So ok, can any of you help? Thank you in advance!