Thread: Can a cell defined by a formula become an exportable numeric valu.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Can a cell defined by a formula become an exportable numeric valu.
CopyPaste SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 08:11:00 -0700, kate wrote:

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

Reply With QuoteReply With Quote