Hi All,

I have a data validation list containing every date for the 2013 calendar year. There are blank cells below that I type the activities I did on any particular date selected. A second sheet uses IF statements to copy that information into corresponding date-activity cells. I have a macro button that advances the date and clears the form but if I try to manually go back and select a previous date, it wipes out any data I typed into those cells before. Is there any way to make sure that when I advance date, it saves the information related to past dates?


Thanks!