View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
denvancam denvancam is offline
external usenet poster
 
Posts: 1
Default save workbook, erase data but keep formula

I am trying to save last years workbook, that accumulates data and totals
numbers. I need to erase last years inputed data, but want to keep the
formulaes intact. If I delete the data, it deletes the formulaes, if i clear
contents it does the same to the formulaes. I don't want to re-input the
same formulaes for every month in the year data base.