Hi!
So my title is a mouthful because I don't know how to concisely ask my question, but I have a simple example of what I'd like:
Say you have three rows in Column A that read: 1, 2, and 3
Next to that, there is Column B with the formula applied to all of it's cells that reads: A1*10, A2*10, A3*10, etc.
If I were to insert a row in between rows 2 & 3 and type a number into Column A (ex: 1, 2, 2.5, 3), I want Column B to take that new entry into account and still calculate the above calculation into that new row. How do I go about doing this without implementing a macro?
Thanks!
Bookmarks