Macro to SumIF a reference Quantity

I have a query of data that I need to reorgainize using a macro. I basically need to sumif colum L "TEAM" by referencing it's quantity in column G but the kicker is that I need an absolute value. Then, I need to copy the accounts that make up the sum and place it under the amount column D in worksheet "allocation". I need to loop this through data that will always change. The attached shows my end result better. Your help with be greatly appreciated. Thank you.

Here is what I have so far but doesn't seem to work.

Please Login or Register  to view this content.

Unfortunately this code doesn't work. The team column doesn't get updated when it sums the quantity per team. Ok if you look at the allocation tab you will see what I need the code to cut and paste. So each team has a sum total amount that needs to be cut and pasted over the to allcoation tab along with pos_ind,underlying_Cusip, sum of quantiy,team, Settleday = today(), and Reason code will always be VO. Under the Amount cell I need to paste in the Account and quantity per acct. See the allocation tab before the end result.

I know this is a lot and I can hopefully figure out most of it but I just need a start with the looping and cut and paste process. Please help...