Secret Santa

Hi,

We are doing Secret Santa at work this year and I am organising it. I would like Excel to generate the names for each person (without duplicating) and to keep a record of who has what which I don't really want to see as I don't want my present spoiled! It is just incase someone doesn't being a present in so we can stop them receiving theirs.

Can anyone point me in the right direction on how this can be done?

Thanks,
Emma

Thanks, I have got is sussed.