title: capture data from a cell and paste the value into another cell on a different worksheet
body: <p>I'm making this more challenging in my head than it has to be, but since I haven't been using vba or excel recently I'm using this as my excuse. Please don't question the methodology :) as this is only a small step I'm trying eliminate for someone to save some time, until I can redo the entire process. I would do the reverse, but this is an invoice of sorts that they are using....</p>
  
  <p>I'm thinking macro or function is what is needed and not a formula since the data on worksheet 2 will change each month and there is no date I can reference.</p>
  
  <p>What I'd like to do:</p>
  
  <p>I have a cell on worksheet 2 that will change once a month.  I want to place the value of the cell from Worksheet 2 into a cell in worksheet 1 each month that she changes it.  </p>
  
  <p>Each month would be represented in column A and the value of the cell from Worksheet 2 during that month needs to be place in column B.  </p>
  
  <pre><code>Column A         Column B
  12/5/2012        $3,459,877.81 
  1/8/2013         $9,360,785.62 
  2/8/2013        
  3/8/2013        
  4/8/2013        
  </code></pre>
  
  <p>So when she changes worksheet 1 for February the number will populate next to 2/8 and so on.  I was thinking do it when she saves the document, or make it a shortcut she can hit or just scrap it and tell her it's not worth. </p>