Hi,

I need to import data at end of month and add percentages/totals. The
problem is the length of the columns will be dynamic so I need to calculate a
range of cells for which percentages and totals are required (see below
example). The 'TYPE' column will cause the report to lengthen as new types
are encountered month to month. I need to determine the number of
percentage/total cells per TYPE and add/replace any existing cells in each
column (jan count column will lengthen if feb has more TYPEs, so I have to
re-populate cells for totals/percentages). How do I dynamically get the range
of TYPE cells and use to place new formulas in percentage/total columns?

TYPE TOTAL JAN COUNT JAN % FEB COUNT FEB %
Call back 15 5 33% 10
66%
Dispatch 20 10 50% 10
50%
....