Hi Guys,

I'm hoping you can help point me in the right direction with a query

I'm keeping a worksheet called "transactions" which has approx 1000 unique users with details that looks like this

person1 opening balance 100
person1 Prize +10
person1 Sale -50
person2 opening balance 10
person2 Prize +40
person2 sale -50

I need to pull each unique person into another sheet "Balance Summaries" with a total balance like this
Person1 60
Person2 0

but I need the "Balances Summaries" Sheet to automatically update anytime the "Transactions" sheet changes.

Is this possible ?

Please & Thanks
Saz