Change from "Annual" to "Monthly" report w/o loosing functionality... Help!

How can I change this "Annual" Financial Report to a "Monthly" Financial Report without loosing the current functionality. I want to be able to use months (January, February, etc) instead of years (2016, 2015), but when I try to do so the functionality is lost. I'm having problems with the calculation tab, where all the data is being drawn from. When I try to use months, it functionality is lost. Is this just not possible? I have been trying for days and I am not able to do so without loosing the functionality.

Any help would be appreciated!

On the "Financial Data Input" tab, I tried to replace the years with months and most of the functionality was lost. It will return the value for that current month, but not the previous month. All data concerning the previous month shows blank or "N/A" if not using years. Without the returning the data from the previous period/month, most of the functionality is lost.

I tried to change the "Calculations" tab so it can work with text data but it looks like the the formulas are based on numbers, it does not recognize text data. For example, it uses a numbered position to return a value that feeds to the ket metrics section. That position is generated based on a year. For some reason, replacing it with a month does not return the same results.

See attached.

Changed year headings to months and highlighted changed formulae.

See if this works for you.

I will detail formulae changes if all is OK.

WoW, that's exactly what I was trying to do. Yes, if you could explain how that was done that would be great!

Named range "lstYears" contains months "Jan" to "Dec". NOTE range needs to be adjusted to $N$3 rather than $I$3

In Calculations

in D3: =MATCH(C3,lstYears,0) returns relative month number ( 1 to 12)

in D4: =D3-1 i.e. previous month number

in C4: =INDEX(lstYears,,D4) previous month from C3

in F6 to C6: =MAX(G6-1,0) returns relative month numbers from G6: if month number is <= 0 then set to 0.

in C8 (copied across and down) =IF(C$6<=0,NA(),(INDEX('Financial Data Input'!$C$4:$I$18,$A8,C$6))) returns data from selected month. If month <=0 then set to "#N/A"

in c15: (copied across and down) =IF($B15="",NA(),IF(C$6<=0,NA(),(INDEX('Financial Data Input'!$C$4:$I$28,$A15,C$6)))) returns data from selected month. If month <=0 then set to "#N/A"

in Financial Report:

L2: List of Months

F15: ="LAST MONTH (" & INDEX(lstYears,,MATCH(SelectedYear,lstYears,0)-1) & ")" returns "Previous month" from Match of entry in E15


I think that's it!!!