I'm using an XL workbook that works well but has a big design flaw. I'd
like to start fixing this, if possible, but I need a push in the right
direction.

The application is a sports competition scoring program. For a typical
competitive group, personal info is in columns A to C (number(ascending),
LName, FName). This part of the data is populated from another worksheet
named MasterRegister. Each athlete's scores for various heats are entered
in columns D to Z. Each competitive group's data is on its own worksheet.
(tyro, argo, mini, etc)

All works well EXCEPT... sometimes an athlete is added (or deleted) to
the MasterRegister at the last minute, or even during the competition. As
expected, this athlete shows up automatically on her group's worksheet, but
the scoring data doesn't adjust to accommodate her. There may now be 11
athletes in A2:C12, say, but scoring data only in D2:Z11. From the new
arrival down, athletes are no longer matched with their own scores.
Similarly if an athlete is deleted from a group, I'd like her scores to be
deleted as well. I need to somehow ensure that each athlete and her own
scores are always in the same row, despite additions and deletions.

I'd really appreciate any general suggestions or hints as to how to proceed.

much thanks
Giselle

Look at whatever is getting the name into the right location and see how
that is being done. Perhaps you can adapt it to how the scores are being
updated.

--
Regards,
Tom Ogilvy

"Giselle" wrote in message
...
I'm using an XL workbook that works well but has a big design flaw. I'd
like to start fixing this, if possible, but I need a push in the right
direction.

The application is a sports competition scoring program. For a typical
competitive group, personal info is in columns A to C (number(ascending),
LName, FName). This part of the data is populated from another worksheet
named MasterRegister. Each athlete's scores for various heats are
entered
in columns D to Z. Each competitive group's data is on its own worksheet.
(tyro, argo, mini, etc)

All works well EXCEPT... sometimes an athlete is added (or deleted) to
the MasterRegister at the last minute, or even during the competition. As
expected, this athlete shows up automatically on her group's worksheet,
but
the scoring data doesn't adjust to accommodate her. There may now be 11
athletes in A2:C12, say, but scoring data only in D2:Z11. From the new
arrival down, athletes are no longer matched with their own scores.
Similarly if an athlete is deleted from a group, I'd like her scores to be
deleted as well. I need to somehow ensure that each athlete and her own
scores are always in the same row, despite additions and deletions.

I'd really appreciate any general suggestions or hints as to how to
proceed.

much thanks
Giselle