View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kate kate is offline
external usenet poster
 
Posts: 112
Default Can a cell defined by a formula become an exportable numeric valu.

I have a worksheet where I have calculated many cell values from formulas
based on other cells. However, I want to export these calculations to another
worksheet so that I can compare them with other calculations. When I try to
export this information it all becomes error symbols because the cells on
which the formulas depend are absent. Is there a way to avoid this problem