Hi,

I have a table with Month (header) and values (lines) and whenever the month changes the values in current month needs to be moved or shifted to previous month automatically. I have just written formula for changing the month based on current date but not able to achieve the same for values. I know only basics in excel and any help would be appreciated!

[attachment]t1.JPG[/attachment]