I have 3 columns, 1 for the current amount, the 2nd for the previous and the
3rd for the total. The following week, the current week column will become
the previous week. Meaning I will have to move the information over to the
2nd column and I will input new numbers into colum one for the "new current
amount". My problem is once I change the information in colum 1, the "total"
colum will also change. My problem is, I need this to be ongoing for the
entire month. Hope this make sense