Forum Discussion
Help with VBA Code
That looks great and works when I added it to the workbook! Thank you for your help!
That looks amazing! However, I don't understand the LAMBDA function so it is a great opportunity to learn!
I simplified the table I originally sent, so I copied the actual sheet into your workbook (only values as many of the cells are filled with formulas and data from other sheets). If possible, can you transfer this function to the sheet2? The output can be anywhere since I will copy the values to a different location.
Hopefully I will be able to copy your version directly it into my workbook without changing any of the cell addresses.
The workbook is set up to handle 45 golfers, if more or less golfers show up, will the table need to be adjusted in the formula or will the formula return a null value? This is why I have a player count at the top of the page so I can adjust the tables and ranges based on this value.
Again, thanks and I envy your skills!
first off, yes this new forum software has some delay/scan process that can sometimes take quite some time which is annoying.
second, i love and appreciate the attitude and hope you learn LAMBDA and new functions that can make your life easier. They are not too hard to learn when you break them down and learn them a little at a time.
I am attaching the updated sheet. you will notice the only thing I did was change the 1st 2 lines to point to the new ranges and used regular range references instead of the (table) structured reference.