Database search

[albertldee]

can someone please help me i have a excel file about 15mg big with the last name of docotrs how can i set up lookup to serch in colum a and return all the docotrs with that last name with the exception that about 7 doctors someime share the same last name just different first name address and phone number, i would prefebly search by last name, or is there any easy serchable database program that anyone can recomend
This message was edited by albertldee on 2002-08-23 14:30

 

[Gaijin]

There are ways to do this in excel however since you are doing database type searching it might be easier to import your table to Access and do your queries there. If you have Access.

 

[Joe Was]

For the code below to work you need two sheets one for the data and one for the search results. The code below go's into a Module. Each row with the same name as is in F4 will be copied on to the "Found" sheet from the "Names" sheet. JSW

Sub myFind()
'Find by search Name in cell F4.
'From name list Starting in A1, A1 is the lable "Name."
With Worksheets("Names")
.AutoFilterMode = False
.Range("A1").AutoFilter

'Type the name you want in cell "F4."
.Range("A1").AutoFilter Field:=1, Criteria1:=Range("F4"), VisibleDropDown:=False
.UsedRange.SpecialCells(xlCellTypeVisible).Copy _
Destination:=Sheets("Found").Cells(1, 1)
Application.CutCopyMode = False
.AutoFilterMode = False
End With
Sheets("Found").Select
Range("A1").Select
End Sub