0
Undo
Votes
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]
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]
There are no replies made for this post yet.