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

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

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

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

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

database 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

database list
 

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