Hi

This is my first post! (the start of many I hope)

I was wondering whether it was possible to change to the relevant cells in a worksheet when a different name is selected from a Data Validation List.

At the moment, I have "Name 1", "Name 2" "Name 3" in a Data Validation list. In the same sheet, I have created a table for them to input data (i.e. no of calls taken, no. of complaints etc). If possible, I'd like the data in the table to change to the relevant Person's data automatically, when this name is selected from the drop down list.

Apologies if I haven't made the issue clear enough.

Thanks,
Mo