retrieve row data

i have one sheet


serial no. data1 data2 data3 data4
1 asd asd asd asdf
2 sef *** dfgdgf asdf
3 dasdf dsfd sadfs sdfsdf
4 dsfds dsfsad sdfsa ssf
5 gfdg dgfsd sdgfdsa were

when i click on serial it shows me the row data on other sheet

for example
if i click on 2

serial no. data1 data2 data3 data4
2 sef dfgdgf asdf

it show row2 data on other sheet

i also attached the file with this thread


Solved with this

Originally Posted by JBeaucaire

Like so:

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column = 2 And Target <> "" And IsNumeric(Target) Then
        With Sheets("Sheet2")
            .Range("C7").Value = Range("B" & Target.Row).Value
            .Range("C8").Value = Range("C" & Target.Row).Value
            .Range("C9").Value = Range("D" & Target.Row).Value
            .Range("F8").Value = Range("E" & Target.Row).Value
            .Range("F9").Value = Range("F" & Target.Row).Value
            .Activate
        End With
        Beep
    End If
End Sub

OK, now it's your turn. If your "requirements" change again you take a stab at changing the code given to match your new requirement and then ask us about your code and your attempts, OK?