Adding rows to the data array used in an Index function
If I add rows to my data set...
1) Will the array automatically adjust?
2) Will any cells that reference the cells beneath the rows I add
automatically adjust to the new locations? Or will I have to manually go
into every index and update the row number needed??
Thanks!
|