database list

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

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
>

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
> >

Yes. If you include the other column headings in the Criteria Range, you
could use multiple criteria. For instance, you could pull records for
employees hired after 06/15/2005 who earn more than $20,000.

Actually, Debra Dalgleish has some really good Advanced Filter information
on her website:

http://www.contextures.com/xladvfilter02.html

Does that help?

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


"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
> > 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
> > >

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
> > 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
> > >

Maybe just selecting those columns and doing Data|filter would suffice.

You could use the dropdown arrows to show the values you want to see.



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

--

Dave Peterson

ok the auto filter can work for most of it
thanks a lot
--
gtsch


"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
>