Help with creating new tables from existing ones

Hi Dryeth

Sorry, but I think I got a bit carried away on this one.

As you suggested, the first table was a bit easy, so I've shown the number of seasons, but also added the range of years that were played (and then shown if there were any breaks.

Again, apologies for the second sheet - no "if" statements were used (if you ignore the "iferror" statements)
To get the figures you asked for was OK, and needed no macro. But then I realised that you need a system for updating for any new players. This I have achieved by a macro. I have attempted to explain how it works, but feel free to ask about it.

To use the second sheet, you need to enter the season that you are interested in and the figures will populate the sheet, highlighting the highest team score and showing the highest team scorer.

I think I've covere all your points, but if not - let me know

Regards
Alastair