Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vacation Time calculation... HELP! brubru Excel Discussion (Misc queries) 1 July 22nd 06 10:10 PM
Lookup returns wrong value motorjobs Excel Worksheet Functions 5 June 21st 06 11:49 PM
holiday dates bucci Excel Worksheet Functions 4 June 15th 06 09:35 AM
Formula for year in school? Freshman, Sophmore bob the bolder Excel Worksheet Functions 3 May 2nd 06 09:57 PM
How do I get Excel to automatically calculate salaries actually received in financial year? Kei Excel Discussion (Misc queries) 0 March 3rd 06 10:26 AM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"