Hi!
I have a problem. I have a file called "Invoice.xls" and a file called "Sale Calc.xls". I have a formula that calculates a value in "Sale Calc.xls". "Invoice.xls" then references to this calculated value. The calculated value is in worksheet "Sale Calc" (of file "Sale Calc.xls" at cell location I5. How do I get "Invoice.xls" in worksheet "Invoice" to reference I30 (in Invoice) to the value in I5. I don't want to use the Paste Special thing. Is there a way to do this without using VB or macros...Im a newbie What I am basically trying to do is reference a whole bunch of values in Sale Calc to Invoice and replace the reference formula... hopefully I'm being clear. Thanks
I have a problem. I have a file called "Invoice.xls" and a file called "Sale Calc.xls". I have a formula that calculates a value in "Sale Calc.xls". "Invoice.xls" then references to this calculated value. The calculated value is in worksheet "Sale Calc" (of file "Sale Calc.xls" at cell location I5. How do I get "Invoice.xls" in worksheet "Invoice" to reference I30 (in Invoice) to the value in I5. I don't want to use the Paste Special thing. Is there a way to do this without using VB or macros...Im a newbie What I am basically trying to do is reference a whole bunch of values in Sale Calc to Invoice and replace the reference formula... hopefully I'm being clear. Thanks