Select a cell in your main database and do Data Filter
AutoFilter............then select an arrow at the top of a column and choose
a offering.............to reverse everything and return back to normal, just
do Data Filter AutoFilter again, it's a toggle..........

Vaya con Dios,
Chuck, CABGx3



"gtsch" wrote:

what would that formula look like?
and what i want is to be able to search on any of the information and get
all of the matches and the other info that goes along with the matches, will
this do that?

thanks
--
gtsch


"Ron Coderre" wrote:

If it's not absolutely necessary to put the data on a different sheet, maybe
Advanced Filter will work

If your data is in Columns A,B,C,D

F1: hire date
F2: (enter a date here)

H1: hire date
I1: name
J1: job
K1: salary

Select your data range
DataFilterAdvanced Filter
Select: Copy to another location
List range: (already selected)
Criteria Range: F1:F2
Copy To: H1:K1
Click [OK]

That will create a listing of the records that match the critera date.

Does that help?

***********
Regards,
Ron


"gtsch" wrote:

trying to make a database that is just a list on sheet2 and on sheet1 if i
type a certain value from that database i want all of the information from a
row that has that matching value
ie

hire date name job salary
12/01/05 JD Janitor 100
12/01/05 CJ Manager 500

if i type 12/01/05 in the hire date on sheet 1 i want all of this info to
show
if i type JD in the name on sheet 1 i want just that row to list