Auto entering next column

[anangelseyes]

I am working in an ongoing spreadsheet. I have two colums side by side that contain information pertaining to a person. (name and title respectively) I want to be able to enter the person's name in the first column and have the next column auto fill with their title and then jump to the third column.

(ex. John Smith typed into column one, enter, Manager automatically appears in column two and I'm ready to go on with column three)

Is this possible?

If so (NO technical terms please), how can it be done?

Any and all suggestions are greatly appreciated! :wink:

Thanks

 

[lenze]

You will need a VLOOKUP Table. Make a table on another sheet with the Names in the First column and the Titles in the second. Name the table, Insert>Name>Define (say myTitles). Place the following in the WorkSheet module. Right Click on the sheet tab and choose View Code.

Private Sub Worksheet_Change(ByVal Target As Range)
       If Target.Count > 1 Then Exit Sub
       If Target.Column <> 1 Then Exit Sub
       Target.Offset(0,1) = Application.WorkSheetFunction.VLOOKUP(Target,Range("myTitles"),2,0)
       Target.Offset(0,2).Select
End Sub

This assumes the name is in column A

lenze

HINT: Use a Data Validation drop down for your names