I have found one problem when i come to format the results page for
presentational reasons. As you pointed out, there can be situations
when there is not enough members to constitute a full team, (in fact
we had this problem only Sunday.) In this case, how would extra rows
be inserted for the missing team members, (either blank or with dummy
scores of zero), as I plan to write/record a macro whereas it takes
the team results sheet and formats it by moving the data from the
table to elsewhere.

If I simply copy the data as it is now, I will come unstuck when a
team in future has more or less than the cell ranges I have defined to
move for this set of results. Since each team has 4 members, inserting
blank rows in means I can define each range for novice/experienced and
each university.

I was thinking of inserting a new row immediately after the results
that are there, achieved by counting the number in each team and an if
statement.


"Tom Ogilvy" wrote in message ...
It definitely could be tweaked to achieve your presentation objectives.

--
Regards,
Tom Ogilvy

"Steve Hill" wrote in message
om...
Thanks a lot, this works just fine. I may tweak it into something more
presentable when I have the time and more knowledge in the subject,
but for now it does exactly what I asked for and that is the important
thing.

Thanks