Forum Discussion
Help with VBA Code
That looks great and works when I added it to the workbook! Thank you for your help!
Thank you, this is great!
Originally I sent a simplified version of the input data, so I've added the full sheet to your workbook (Sheet 2).
I don't fully understand the LAMBDA concept but will use it as a learning opportunity!
What I am unsure of if additional golfers are added, will the table automatically expand to accept the additional rows or will there be null values?
Given my limited knowledge, could you move the function to Sheet 2 and will I be able to simply copy it into my workbook?
My workbook is set up for 45 golfers, that is why the sheet looks different. You can put the output table anywhere as I will simply copy the value for use in other parts of the workbook.
Many thanks and I envy your knowledge!