Think about using a pivot table instead of a macro... That way, you
don't have to subtotal anything. The pivot table does it for you.
You can set the table to refresh up opening the workbook, or write a
macro to refresh whenever you want.

Rob


BrianMo wrote:
I am trying to create a macro that when run will take information from one
sheet and copy it into another. On the first sheet called Multi basis report
there are 4 columns. (B) Security Id, (C) Security, (D) Realized G/L, and (E)
Total Gain/Loss. I need to take the security Id #, the security name, and
it's realized gain/loss and paste it onto a sheet named 2006 Sched D changes
for transfers. The issue I am having is that on my first sheet there are
multiple lines for each security Id instead of just one consolidated line. I
have created subtotals for each security so there is a single line with the
security Id and the total column summed up. Any help that can be offered is
greatly appreciated.

Thanks in advance,
Brian Monaghan