|Returns a reference to a range that is given a number of rows and columns from a given reference.|
|=OFFSET( reference, rows, cols, [height], [width] )|
|reference||The starting point supplied as a cell reference or range.|
|rows||The number of rows to offset below the starting reference.|
|cols||The number of columns to offset to the right of the starting reference.|
|[height]||The height in rows of the returned reference.|
|[width]||The width in columns of the returned reference.|
Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.