title: Excel to copy realtime data and create a chart out of it
body: <p>I am very new to VBA programming. </p>
  
  <p>I have a excel sheet where real time data is populated to a  cell say for example Sheet1.A6   everysecond. </p>
  
  <p>I am in need  of a macro which will run every 1 minute  to copy the Sheet1.A6 value to another sheet along with timestamp  like value in Sheet2.A and timestamp in Sheet2.B .</p>
  
  <p>Sheet2 Output will be like</p>
  
  <p><strong>Value *   Time</strong> </p>
  
  <p>23.1    *    11:00 AM</p>
  
  <p>22.5    *   11:01 AM</p>
  
  <p>22.6    *   11:02 AM</p>
  
  <p>.......... 
  .............</p>
  
  <p>Thanks for your help.</p>