Random automated number allocator

Hi all,

Thank you to everyone for your help so far on this site.
I am slowly getting more competent with excel, but need some help - perhaps direction where I could find out how to do this.

I have taken on a project that is would seem is far out of my league right now, but need to deliver.

I have attached the example spreadsheet to help explain what I am trying to achieve, which is basically a random automated number allocator.

Look forward to receiving your replies,

Thanks,

Dan

Example.xlsx