View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jonsson
 
Posts: n/a
Default Refer to formula in another sheet


Hi all,

I thank you for your effort to help me, but I have decided to put the
splitted formula into two cells in the same sheet as the calculated and
tested cells. That did the trick for now, but it's not the best solution
as I have 30 sheets containing over 800 rows with formulas in it.
Therefore I wanted two "mainsheets" to calculate the others.

//Thomas


--
Jonsson
------------------------------------------------------------------------
Jonsson's Profile: http://www.excelforum.com/member.php...fo&userid=5472
View this thread: http://www.excelforum.com/showthread...hreadid=491755