I am preparing a scoring workbook for my golf group. I have one spreadsheet
that will contain all historical scores by member. This includes the current
handicap calculation. Not all players play every time, so the number of data
entries in the historical spreadsheet is not the same for all members. I
want to create a second spreadsheet that will have only the current handicap
for each member linked to it. I am trying to figure out how to link the last
non-zero entry in a specific row of the historical spreadsheet to this second
summary spreadsheet. The last non-zero entry in each row of the historical
spreadsheet will change every time a person plays a round.

Any suggestions on this can be done in EXCEL?


--
Thanks for your help