VBA to keep a Running Total per person

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

Hi
Use

Formula:

Please Login or Register  to view this content.

See the file for clarification

Hi José,

that works perfectly thanks so much..

Can I ask if there is a quick way to get a unique list of persons to another tab to run this ?

I tried the advanced filter but this only works on the active sheet ?

TIA
Saz

Hi
You can copy your column A in transaction sheet , paste the to a new column and in data menu chose remove duplicates.

great - Again Thanks a mill

I am happy to have helped.
Do not forget to mark this thread as SOLVED.