I need to figure out how to automatically save a cell into a second cell by date. For instance; I need cell A2 on Sheet 1 to save into cell A2 on Sheet 2 by todays date. When I open the file tomorrow I need to still see that information, then I need cell A2 on Sheet 1 to save into cell A3 on Sheet 2 by tomorrows date. Is this even possible? Any information would be helpful. Thanks.