Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vacation Time calculation... HELP! | Excel Discussion (Misc queries) | |||
Lookup returns wrong value | Excel Worksheet Functions | |||
holiday dates | Excel Worksheet Functions | |||
Formula for year in school? Freshman, Sophmore | Excel Worksheet Functions | |||
How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) |