 |
|
|
|
|
|
|
|
|
The Dynamic Ranges page is arguably the add-ins most powerful and useful feature. Dynamic Named Ranges are ranges that will expand/contract according to the data in the range. The great part about this is your named ranges will only include those cells that house data. This makes them ideal for Pivot Tables, Charts, Validation Lists, and restricting formula calculations.
There are 8 different types of Dynamic Ranges you can create;
- Numbers Only: The range will expand/contract as many rows or columns as there are numeric cells (cells housing numbers) in your Lead Column, or Row of your specified specified range.
- Text and Numbers: The range will expand/contract as many rows or columns as there are text and numeric cells (cells housing numbers or text) in your Lead Column, or Row of your specified specified range.
- Last Text Entry: The range will expand/contract to the last row or column, of your Lead Column, or Row, that houses text. The great one about this is you can have blank cells between your entries.
- Last Numeric Entry: The range will expand/contract to the last row or column, of your Lead Column, or Row, that houses a number. The great one about this is you can have blank cells between your entries.
- Monthly: The range will expand/contract one row or column per month up to 12. This one is ideal for charts and Pivot Tables that need updating only once per month. Set your dynamic range, use it in your chart or Pivot Table reference and leave it for the year. Your chart will update automatically the 1st day of each month!
- Weekly: The range will expand/contract one row or column per week up to 52. This one is also ideal for charts Pivot Tables that need updating only once per week. Set your dynamic range, use it in your chart or Pivot Table reference and leave it for the year. Your chart will update automatically the first day of each week!
- Day of Month: The range will expand/contract one row or column per day for any month, max of 31. This one is also ideal for monthly charts or Pivot Tables that need updating only once per day of each month. Set your dynamic range, use it in your chart or Pivot Table reference and leave it. Your chart will update automatically each day of each month.
- Linked to Single Cell: The range will expand/contract one row or column according to the number you have in your specified Linked Cell. This makes the Linked to Single Cell choice one of the most generic and flexible.
Excel Named Range Manager 
Excel 97 or above |
Secure Payment Options |
30 Day Money Back Guarantee & Huge Discounts for Unlimited Licenses
| Buy on its own or
buy as part of the
Excel Add-ins Collection for not much more and get our
Complete Excel Course for FREE.
You will be able to download your Excel Add-in immediately
after ordering.
| Order Type: |
|
Single user license =2 users 2 computers| Unlimited user license = unlimited users unlimited computers | Resellers user license = Do anything you like with the add-in, including rebranding and reselling. That is, NO RESTRICTIONS AT ALL. Please email the support address and include your order number so we can send you the code password. Resellers user license ONLY
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS