Hi there Im in the middle of creating a Fantasy League for myself and my friends I have created most of it but im now stuck with a few bits as im still new to Excell.

1. How to freeze the data in a cell after a certain date has passed (the data not the formula that is in there)

2. when creating new Players/teams into a league how can you copy a template add name and all formulas in the cells to change with it without having to manually input every cell?

3. add logins to the players that are in the league so all they can see is the table and there team and to lock everyone else's team so the person logging on can only ammend there team and nobody elses team.

If any you can help with any of these that would be a massive help

Regards
Mike Wilson