View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tjsmags tjsmags is offline
external usenet poster
 
Posts: 21
Default 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.