I have a little spread sheet i am trying to help a friend with, I am learning also here it is .We will say that in column B there is acaluculation that subtracts the day total from yesterday and that number is put in column J each day automaticly .And this number changes everyday the one in J .I want this number to automaticly be put in cell let say K2 from the that days j cell number does this make any since.I just want what ever todays total is from Column J to automaticly show up in K2 ,and so on tomorrow to change with that total from column J 30day in a month I want it to k2 change 30 or 31 time a month thanks for any help.I will have 30 or 31 entrys in column J and that numbers auto in K2 Thanks for any help.