Or you could put something like this into the View Code as a Selection Change. This assumes that the column for selection is Column A. By selecting any cell between 4 and 70 in Column, it will take the user to the "Wahtever" named range.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Column < 2 Then
If ActiveCell.Row < 4 Then
ElseIf ActiveCell.Row > 70 Then
Sheets("Sheet1").Range("A2") = ActiveCell.Value
Application.Goto Reference:="Whatever" '(defined name, refering to a specific cell).
old, slow, and confused
but at least I'm inconsistent!
I would recommend putting all the data, including your list of Names & #'s on sheet2, organized in rows (ie joe in A1, address in B1, # in C1).
(which I have done in sample).
You can use a combo box to select the name/# combination(should put on Sheet!2 also), put the selection in a cell under the box, then use Vlookup to bring in the data for that person you want. You can have each field be in its own cell, or concatenate into one cell(I did it this way).
It is not possible to put the data in in rows, because the data file for each customers are more that 3 lines and varies by customers some times more than 20 lines.
I must say customers data file are separted by new line as I have shown you in my sample file
Answer to you questions:
The data file is exported to sheet2
If there is missing data, it does not come in blank raw, the next raw is phone,
example if address2 is missing for name mark then we get
If the phone raw is missing, simply there is empty line and after that there is another name with address and phone
Address 2 Qeen st