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.
30 Day Money Back
Guarantee On All Excel Add-ins!
Big Discount for
Unlimited License
You will be able to download your Excel Add-in immediately after ordering.
30 Day Money Back Guarantee Excel 97 through to 2003 Compatible.
Payment
Problems/Options SAVE
by buying as part of a
Add-ins
collection
