Populating a cell when another is clicked.

[garethd]

Hello, got an excel question.

Imagine I have 4 columns and 20 rows as a matrix of questions. Column E is a total.

When I simply click cell A1 I'd like A5 to auto populate as the number 1. If I were to click C1 I'd like column E to populate as 3 instead.

As I go down the sheet click either A,B,C or D (1,2,3 or 4) from each row, Column E shows the relevant number 1,2,3 or 4.

Kind of like a multiple choice but with cell clicks as the choice part.

Any ideas?

Thanks

[HaHoBe]

Hi, garethd,

right-click Tab, choose View Code (code goes behind the sheet where event shall take place):

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A1:D20")) Is Nothing Then
  Cells(Target.Row, "E").Value = Target.Column
End If
End Sub

Ciao,
Holger

[Richard Buttrey]

Hi,

Does the attached help?