Excel Solution - How to Create Dynamic range - example 1.avi
We always create range reference in formula in excel that is fixed such as $A2:$A15, if we add record, we also need to change the reference in formula.
With this dynamic range techinque, everything can be more flexible,
after using this techinque you can add records and no need to change the range reference, see this tutorial to know more.