i have reports showing a 3 mo. trend. i've programmed the months to
automatically update, but i don't know how to program the data for that month
to update as well....(i.e.)

if jan=1, dec=2, and nov=3 in this month's report; next month my report will
incorrectly read...feb=1, jan=2, dec=3. i need the current month's
corresponding cells to clear, and the cells that correspond to prior months
to automatically update. my report for next month should show...feb=no data,
jan=1, dec=2. right now i am clearing and then reentering data.