represent values from one book in another

K

Kate

Hello there,

I have two workbooks ,one contains fiscal information which summes up to one
total value and I want this value to be rolled up into another workbook, but
I want it to stay a value rther then become unrecognisable by formulas (I
have tried hyperlink function and my number rolled up from another workbook
wasn't recognised by formulas anymore). Which formula/function can I use to
achieve the roll up?

I hope someone can help!

Thank you
Kate
 
D

Damon Longworth

With both workbooks open, type an equals sign (=) and then navigate to the
target cell. Hit enter and the link will be created.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com
 
Top