Data Collation

Hi folks,

I'm not sure this is even possible but here goes - (please see attached file)
This is chart to keep a record of business referrals between people.

1. In the column 'from' is it possible to start typing a name in the cell and excel find matches for you to select from?

2. Is it then possible for the chart further across to register in the appropriate cell that the referral has happened and to keep a running tally?

Once I've learnt how to do this, if at all possible, I shall be back to learn even more.

Andrew

PS. Sorry but I'm really out of my (limited) depth on this.