hi
this might work for you. it is worksheet code. right click the sheet tab
then click view code. paste the below code into the code window.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim r As Range
Dim ro As Range
Dim n As Long
n = Range("A1").Value
Set r = Sheets("Form").Range("B1")
Set ro = Sheets("Data").Range("A" & n)
If Intersect(Target, r) Is Nothing Then
r.Value = ro.Value
r.Offset(0, 1).Value = ro.Offset(0, 1).Value
r.Offset(0, 2).Value = ro.Offset(0, 2).Value
End If
End Sub

regards
FSt1

"Carla" wrote:

This is difficult to ask...
I want to create a form in excel on one tab with a spreadsheet of data in
another tab. On form tab I would like to simply type in the line # for which
I would like the data to populate from the data tab.

Form tab:
A1 type 1 (to retrieve data from line 1 on data tab)
A2 return Column A of Row 1 from data tab
A3 return Column B of Row 1 from data tab
A4 return Column C of Row 1 from data tab

Thank you all you wonderful forum helpers out there!
Carla