title: Creating Dynamic column in Excel
body: <p>I am new to Excel and I trying to carry a complicated (for me) project. I would like to create a dynamic column in excel. Let me explain what I mean. Assume that in column A we have numbers 1,2,.. ,10, sitting on cells A1 through A10. In column B I want to get the squares of those numbers, i.e. in cell B1 to have 1, in B2 to have 4 ... in B10 to have 100. Squaring is just an example, it could be another more complicated function.</p>
  
  <p>The problem is that I don't know how many numbers I will have at column A. I may have 10 numbers, I may have 200 numbers or 1000 numbers. I want the squares to be calculated automatically without me having to intervene at all. For example, in the example with numbers 1-10 above, if I add number 11 at A11, I want to get 121 at cell B11 automatically, without any intervention. Also, if I delete numbers 10 and 11, I want to get empty cells at B10 and B11, not zeros. I have done it in VBA, now I searching a way to do it in Excel directly. Thanks a lot in advance.</p>