Copying formulas without linking books
Posted by Cat on February 13, 2002 8:31 AM
I have two workbooks. Both are identical in terms of formatting except for the filename (they have the same format but different numbers). The have multiple worksheets and on the first page there is a formula that adds cells from each sheet to give one total. I would like to be able to copy this "grand total" formula to the new workbook (we do a new one for everyday)so that I don't have to type it in everytime. However it is trying to link the two workbooks and I do not want it to. I just want the 'absolute' formula. PLEASE HELP!!!!
Posted by Mark W. on February 13, 2002 8:36 AM
What's the formula? [nt]
Posted by Cat on February 13, 2002 8:51 AM
The formula is...
I cannot give you the exact formula b/c it is contains link to confidental info; however, the same problem applies with a simple sum formula like this.
This is what I want and what is in the first book:
=$A$8+Sheet2!$A$8
what shows up in the other workbook when I copy and paste special is this:
=$A$8+[Book1]Sheet2!$A$8
Posted by Mark W. on February 13, 2002 8:58 AM
Instead, use...
=INDIRECT("A8")+INDIRECT("Sheet2!A8")
Posted by Cat on February 13, 2002 9:02 AM
THANK YOU!!!
