Macro to go through specific columns in a worksheet

Hi All

I have a workbook consist of different worksheets, One of these worksheets called "Result" which is picking data from the other worksheets using a specific formula "simple equation". The "Result" worksheet should works on a year basis (according to the years (rows) and data (columns) in the other worksheets). Hi All

My problems are:
(1) I need my macro (Macro3()) to be modified so that I can go through all columns in "MM" worksheet.
(2) I have a macro called ToEndYear() has a for loop and If statement, I could not figure out why it is not working.

I have managed to change some of my macros, so I have attached a new file.

Any help plzzzzz