title: How to add 1 to the cell below every second or period of time
body: <p>Hi guys I'm having some difficulty finding how to do the following. I need to have a column add 1 to every cell below the starting cell say <code>A1</code> every second since a time has passed say <code>13:00:00</code> in cell <code>B1</code>. Consider every cell in column <code>A:A</code> is blank I need to either use excel or vba to put a 1 to the cell below , every second, as already mentioned. So  after a minute I will have the below up to 60 starting the count from A2</p>
  
  <pre><code>A
  0
  1
  2
  3
  .
  .
  .
  ...
  60
  </code></pre>
  
  <p>until I specify stop in a cell e.g. <code>c1</code> having <code>13:01:00</code> or <code>D1</code> having <code>13:01:00</code> and <code>C1</code> having <code>STOP</code></p>
  
  <p>I would prefer to do this with excel formulas but I am not sure if it will be efficient since I will have up to nine column doing this at the same time and they will run from a few minutes to a few hours, possibly days. 
  So a UDF would probably be better - I will probably need to test both methods</p>
  
  <p>Once the time has stopped I need all the cells in the column to be put back to blank including the <code>0</code> :)</p>
  
  <hr>
  
  <p>What I am actually doing is find the lowest low or lowst high frm the point in time when I opened a trade with a program called multicharts refering to its DDE connectoin formulas. The last input is the time since in any period I like as long as it is present in multicharts. I can have 1 second - 5 seconds - 10 minutes. 
  The formulas are like 
  <code>=RTD("mcrtdserver.rtdserver","localhost","Symbol","EUR/USD","1 Second","SymbolData","High",0)</code>
  where the 0 is the present 1 second or it can be present 5 minutes. Hence I can use the 1 and 2 to find the data from 2 seconds ago up to however many seconds ago I opened the trade. Essentially I'm looking for the most practical way then to refer to these formula(s) to find the minimum or maximum of the high / low. Low formula is just 
  <code>=RTD("mcrtdserver.rtdserver","localhost","Symbol","EUR/USD","1 Second","SymbolData","Low",0)</code>
  where it is more practical to work in 5 minutes, 15 minutes, 30 minutes and hours as they will be present in multicharts quite frequently. 
  I am just trying to get my head round how best to do this - whether it would be a vlookup table with time from / time until using some intervals to hone in on the larger time frame or something else. I would then try to paste.value the minimum or maximum value of the high / lows recorded before clearing the column to make use of the value so that bit isn't so important right now. </p>