Lisa

To help clean up your spread sheet this is what I have done and it worked
for me. Make your copy by renaming it like JLatham suggested and then slect
the entire sheet. (The easy way is to click on the little grey square between
the first row and the first column.) the go to EditGotoSpecial select
constraints, and ok out. Now all of your inputted data is selected and none
of the formulas. Because they are selected, I like to right click and select
"Clear contents". Now you are ready for 2007! I would also save a copy of
this for 2008 or save it as a template and use it every year. Please do this
on a copy first to make sure it is doing what you want!!!!

Mike Rogers


"Lisa" wrote:

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 ?