ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   School year repetitive listing (https://www.excelbanter.com/excel-discussion-misc-queries/106717-school-year-repetitive-listing.html)

tjsmags

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.


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com