It would not let me post more than that. Yes it is a Profit & Loss. I am
not sure what you mean by copy to retain? I have to show 2008, 2009, 2010
and then my last one would be listed as Budget 2011. This is why I need to
get rid of the 2007 info. I need this information set on the worksheet this
way so they can see the years to compare. If there is an easier way to do
this I would love to know. I am fairly new to the whole excel thing.

Thanks for your help!

"trip_to_tokyo" wrote:

Renae, your posting is not very clear.

1. By P & L do you mean Profit & Loss?

2. If you are deleting the oldest year 2007 why not copy it instead that way
you still retain the data that you are currently deleting.

3. If you delete things you normally lose them.

4. If you have four years worth of Profit and Loss figures maybe set up
different Worksheets within the same Workbook for each year.

As an alternative keep the different years in different parts of the same
Worksheet.

Please click on Yes if my comments have helped.

Thanks!


"Renae" wrote:

I have a P & L that contains 3 years of info. I have to delete the oldest
year (2007) and put in our actual numbers for year ending 2010. Will I lose
all of the formulas when I delete all of the 2007 numbers? Is there an
easier way to do this?