VBA Help

[Marino M]

Hi,

I have a list of clients with their associated outstanding dollar
amount and their return (%). I would like to know if there is code
that would allow me to break up these clients by return (%) groupings.
For example, I would like to group below 10%, 10% to 17%, and above
17%. So at the client on the list that is just before 10% I would
like to add two rows and put a dollar subtotal in the immediate row
and sum the dollar amounts.

Can anyone help?

Thanks,

Marino

 

[Gary Brown]

I would
(1) use a 'cheater' column with a formula something like...
=IF(A1<10,1,IF(A1>17,3,2))
(2) Sort on the return (%) column
(3) Subtotal using the Data > Subtotals option.

 

[Marino M]

I would
(1) use a 'cheater' column with a formula something like...
=IF(A1<10,1,IF(A1>17,3,2))
(2) Sort on the  return (%) column
(3) Subtotal using the Data > Subtotals option.

Thanks for your input, but I'm trying to make it a bit more automated
and my data changes often. I already have some code built in to pull
my data from a different sheet and sort it but the insertion and
subtotal is a bit more than i know how to do.

Thanks for your help.

Marino