View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Copying worksheet

Sure. Open your 2007 expenses, save it as 2008 expenses. You are now working
with 2008 expenses. Just select the cells with the numeric values you want
to clear and delete the values. Just don't delete any formulas. Then save
your workbook as 2008 expenses.

"jcinbarrie" wrote in message
...
Now using excel 2007. I keep an annual (running) list of medical expenses.
I
would like to copy my 2007 worksheet (created in excel 2003) to use for
2008
expenses. Is it possible to clear the contents of individually selected
cells, like the cost of the medical expense, how much the insurance
reimbursed, and the difference for tax, but maintain the formulas?
Many thanks for any advice,
Judy