mrmmickle1: Thanks for you help too. Your solution did also work but it was just not easy for 10 matches for 20 weeks and multiple tabs.

Now that we are at the end of the season I'll have the data to make sure all the formula's are on all tabs and be ready to blank it for next year.

Oh...how do you mark this solved?