Hi. Working on a macro subtotal in which the amount if data is
variable. Let me elaborate. I am creating a macro to organize a
report from data which is variable. While all my columns of data
remain constant (so it's easy to format and pretty up the report), the
amount of data in the columns changes. One day the data can be only
five rows long and other days, it can be 250 rows long. I have to sort
the data by Provider ID (numeric - column A) and Provider name (alpha -
column B)---this is no problem. I then need to subtotal the Amount
Paid (column K) for each Provider ID. These subtotals would be best
placed at the bottom of the report---the length of which is also
obvioulsy variable. How do I work with variable data in macros?
Thanks so much for your time and brain power!
Joe