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
> Data>Filter>Advanced 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
> >