Profitwyse Advanced Excel & Access Tip Series #4

Excel Automatic Defined Name Resizing

In this Advance Excel Tip Video #4, I am going to show you an advanced tip you can use to create automatically resize an Excel Defined Name range. This is helpful for a number of purposes, the first being the situation where someone else is managing your workbook applications. If you Excel application needs to leverage lists, such as a product list, a list of managers for a drop down box or some other object, then you need to be able to automatically resize the defined name range as items are added and deleted. Without this technique of using the Offset function to resize the ranges, your defined name ranges will be static and require you to manually update the range size when the list changes.

Gaining a competitive edge, which can be as simple as following a formula, will require some infrastructure and tools.  At Profitwyse, we specialize in implementing these tools around profitability improvement initiatives.  If you are a business owner that is struggling to develop processes that deliver goals, contact us today.