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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.