Save Highscore value from one sheet to another using VBA (Doubleclick)

Hello and thank you in advance for your help.

I have this This Book with 2 Sheets.

Sheet "Slots" is where I list and save the info about the game: Name, Highscore Euro and Highscore Multiplier (database)
On the theet "SlotStream" is where i write down the games that I am playing during stream, which betsize I used and the win I got that day.
I wanted to know the best way to keep the Highscores Field on the sheet "Slots" always updated with the higher value using something like doubleclick on the "Win" and "x" cell on sheet "slotStream".
This should return a string with the win value and bet size in parenthesis like you see on B3 and C3 on sheet "slots" for example.
I would need to use VBA code and something like vlookup for reference maybe, but I am not really an expert on these matters.



Would somebody be able to help me?
Thank you.

You don't need a macro or to doubleclick. You can write a formula that will update automatically. Put the following formula in cell B1 of the Slots sheet and since you are using a structured table it should copy down automatically and calculate the max scores for whichever game is listed in column A:

Formula:

Please Login or Register  to view this content.