I have a workbook for each detective in our department. Each workbook has 52
sheets for the weeks for this year 2008. I have copied all these workbooks
into a new folder for 2009 and created a new 2009 date sheet that links and
changes all the dates. Question: Each sheet has the correct date for 2009 ,
but the data is still showing on all the sheets from the 2008 year. How can
I remove the data from each of the sheets or should I have done this
differently?

A simple macro can do the trick. the only thing I would need is thjhe ranges
of cells on each sheet that need to be deleted. i assume there are some
formulas and information that doesn't need to be removed.

"Pammy" wrote:

I have a workbook for each detective in our department. Each workbook has 52
sheets for the weeks for this year 2008. I have copied all these workbooks
into a new folder for 2009 and created a new 2009 date sheet that links and
changes all the dates. Question: Each sheet has the correct date for 2009 ,
but the data is still showing on all the sheets from the 2008 year. How can
I remove the data from each of the sheets or should I have done this
differently?