You can specify the number of rows and the number of columns to be returned. The reference that is returned can be a single cell or a range of cells. It returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The OFFSET function is useful when dealing with a data range that may grow or shrink.
We can use the OFFSET function combined with a COUNTA function to do this.
What if you want a worksheet that references the last row in another worksheet which will update itself automatically as the number of rows in the worksheet changes?
