Hi - I have a data validation cell with a list of names and what i want to do is ...when a name is selected i want to auto populate the remaining columns with the following 5 columns from another sheet to save entering them manually - how can i do this? Open to all guidance :-)