I have a folder with 9 station locations that have a tab for each month of
the year. Now I am ready to start 2007 with the same stations and the same
months but different dollar amounts will be put in each cell through the
year.

Question. Can I make a copy of the the 2006 folder and all the
spreadsheets- save it as 2007 and either clear contents [which I am afraid
will wipe out formulas] or put 0 in every cell [which will be time consuming]
or is there another suggestion. I can also just copy the templates I made
and start from scratch but I am trying to figure an easier way. The only
real hard formula is I have a year to date for each station and the totals
from each month feed into it, that is the one I am not positive will work
with what little I know.

Any ideas ?