Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("B73"), Target) Is Nothing Then
Select Case Target.Value
Case Human: Range("B74:B94").Value = Range("B2:B22").Value
Case Elf: Range("B74:B94").Value = Range("C2:C22").Value
Case Drow: Range("B74:B94").Value = Range("D2:D22").Value
Case Dwarf: Range("B74:B94").Value = Range("E2:E22").Value
Case Orc: Range("B74:B94").Value = Range("F2:F22").Value
Case Centaur: Range("B74:B94").Value = Range("G2:G22").Value
Case Gnome: Range("B74:B94").Value = Range("H2:H22").Value
End Select
End If
End Sub
Bookmarks