Excel Forum
Similar Content
Automatically Copy New Data to Another Worksheet
: This macro allows you to quickly and easily copy all new data from one worksheet to anoth...
Transpose a Column into Multiple Rows in Excel
Tutorial: Convert a column of data into multiple rows of data at a given interval. For instance, e...
Dynamic Named Range in Excel
Tutorial: How to create a named range that expands automatically when a new value is added to the r...



Excel Magic Trick #240: Dynamic Range New Data At Top


OFFSET function. See how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom. See how use the Name Manager (Define Names) to create a named formula that defines a range of cells.

See how to insert a dynamic range formula name into a chart.





Got a Question? Ask it Here in the Forum.