title: Copy sums from one Excel file to another
body: <p>I have one file (Book 1) with a column of numbers and a formula to sum them up. I need to copy that sum from Book 1 to a cell in Book 2, Book 3, etc. I end up copying the formula and moving it, not the sum itself.</p>
  
  <pre><code>Sub CopyInfo()
      experiment1.Range("F7").Value = experiment2.Range("I5").Value
      experiment1.Range("F7").Copy
      experiment2.Range("I5").Paste
      Application.CutCopyMode = False
  End Sub
  </code></pre>
  
  <p>I'm trying to copy from "experiment1" to "experiment2".</p>