School year repetitive listing
I need to set up a TEMPLATE and then use this template (copy and paste it)
for upcoming school years. I want the dates to automatically update after I
copy and paste the data. How do I accomplish this?
For example:
TEMPLATE:
School year 2006-2007 (do I need to put these dates in 3 different
cells...2006 thru 2007...in order for them to automatically update?)
3YR Class of 2017
4YR Class of 2016
K Class of 2015
1st Class of 2014...
7th Class of 2008
8th Class of 2007
Then, I want to copy and paste the above TEMPLATE and have the dates
automatically update for the upcoming school year (i.e. 2007-2008). How do I
accompish this?
thanks.
|