represent values from one book in another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy formulas from one workbook to another 1
lookup to see if multiple values exist 2
Values imported from one workbook to another 1
how can I paste values derived from formulas into a different book 3
Excel 2002 VLOOKUP in another workbook returns #VALUE 1
Offset/match returns #value error 8
Excel formula to incrementally increase a value by 1 every 365 day 2
Excel Help to copy information from one row at a time to another sheet 1

Back
Top