Database search

albertldee

Board Regular
Joined
Aug 22, 2002
Messages
65
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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top