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 ?

I think this will work better for you: Open up the 2006 book, then save as
using a new name for the 2007 book. That will keep all data and formulas and
prevent any references/links back to the original workbook from being
created. Then you should be able to go into it and make appropriate changes
for 2007 at the 'head end' of things and they should roll up. You will
probably have to zero out any typed-in entries in it along the way.

Once you've done that, you may want to consider saving it once again using
another filename so you can just grab it and rename it and set it up quicker
at the end of 2007.

"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 ?

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 ?