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