Excel- Master list, sub list linking 1

[CBFISH]

I am creating a prospect database of sorts that is based on one master list, on it's own separate sheet. Each employee has their own sheet indicating which prospects they are courting.
I would like for my employees to pick a prospect on their sheet, and for it to show up on the master list that they have taken the prospect.
I also have a notes column that I would like updated on the master list as they input notes on their sheet.
Right now I have a validation list they can use to select a prospect. How can I have the master list updated to indicate the prospect is taken, once the employee selects the prospect on their sheet, from the validation list?
Any suggestions are greatly appreciated

 

[SkipVought]

Hi,

FIRST PRIORITY. Read and understand...

http://www.alphabetcitydataworks.com/FundamentalsOfRelationalDatabaseDesign.doc

Then you will understand why you should not have separate sheets for each whatever.

Modify your MASTER to include EmployeeID and Comments.

Then, your application could be a simple as using the AutoFilter to display any Employees data.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[CBFISH]

Thanks Skip,
I thought I was making it more complicated than I needed.
You proved it.
CBF