Conditiontal linking between spreadsheets
 

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

Conditiontal linking between spreadsheets
 

This will return the last (rightmost) non-zero number in the referenced
range:

=LOOKUP(1E100,1/A1:J1,A1:J1)

Assumes there are no logical TRUE entries in the range.

For example:

81,0,79,77,83,0,0,0,75,0

=LOOKUP(1E100,1/A1:J1,A1:J1)

Returns 75

--
Biff
Microsoft Excel MVP


"Golf Scorer" wrote in message
...
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

Conditiontal linking between spreadsheets
 

Biff
THANK YOU. This works great. I have completed my scoring workbook and
even created a linked spreadsheet that can be used to check in players every
morning.

Excellent support
--
Thanks for your help


"T. Valko" wrote:

This will return the last (rightmost) non-zero number in the referenced
range:

=LOOKUP(1E100,1/A1:J1,A1:J1)

Assumes there are no logical TRUE entries in the range.

For example:

81,0,79,77,83,0,0,0,75,0

=LOOKUP(1E100,1/A1:J1,A1:J1)

Returns 75

--
Biff
Microsoft Excel MVP


"Golf Scorer" wrote in message
...
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


.

Conditiontal linking between spreadsheets
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Golf Scorer" wrote in message
...
Biff
THANK YOU. This works great. I have completed my scoring workbook and
even created a linked spreadsheet that can be used to check in players
every
morning.

Excellent support
--
Thanks for your help


"T. Valko" wrote:

This will return the last (rightmost) non-zero number in the referenced
range:

=LOOKUP(1E100,1/A1:J1,A1:J1)

Assumes there are no logical TRUE entries in the range.

For example:

81,0,79,77,83,0,0,0,75,0

=LOOKUP(1E100,1/A1:J1,A1:J1)

Returns 75

--
Biff
Microsoft Excel MVP


"Golf Scorer" wrote in message
...
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


.