copy newest entry to new row and add value to current balance

[goooodrico]

I would like to copy the entries from D-F into columns A-C, but combine those entries summing the Awards given into a total balance. So if an $5 is given to Name1 then the new balance would be $35. Also, if Name3 is given an award would need to add the new name to the balance sheet. Then, I have a sheet "AllOrders" that tracks orders. If name 1 places an order, would need to subtract that order out of his balance. Any help appreciated.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Balance[/TD]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Award[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]name1[/TD]
[TD]$30[/TD]
[TD][/TD]
[TD]name1[/TD]
[TD]$20[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]name2[/TD]
[TD]$5[/TD]
[TD][/TD]
[TD]Name2[/TD]
[TD]$5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]name1[/TD]
[TD]$10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[rconverse]

Why not have three tabs? One being the list of names/dates and then create two tabs for orders and contributions. You can then use the sumif/sumifs function to track the net balance.

 

[goooodrico]

Why not have three tabs? One being the list of names/dates and then create two tabs for orders and contributions. You can then use the sumif/sumifs function to track the net balance.

I don't want a list of 1,000+ names with no balance. I only want the ones with the contributions to be listed.

 

[rconverse]

You could then create a pivot table and exclude anything with a 0 balance. Would that work?

 

[goooodrico]

Yes, pivot tabek works. Thank you

 

[goooodrico]

Now another issue. I have code that protects all sheets. How do i correct this to not protect this one sheet. I get an error with the pivot table because of the protected sheet