Creating a sheet to view rows from another sheet

[jonco]

I have a spreadsheet with 3000 rows of data (colums A-S). One row for data
on each contact. Each row contains a cell (field) for a unique Contact
Number and one for Contact Name among many other cells.
I want to create another worksheet that will have a field that I can enter
either the number OR name of the contact and have it get all the info for
that contact from the first sheet and display it on this second sheet in
different cell locations (all visible on one screen.

Thanks for your help.
Jon

 

[Don Guillett]

Why not just use, on the first sheet

data>filter>autofilter

 

[Dave Peterson]

How about an alternative?

Apply data|filter|autofilter to your range.

Then you can use those dropdown arrows to view the records you want.

 

[jonco]

I want this to be as simple as possible for the user (not very computer
savy). I want them to be able to juast type in a number OR name and click
ENTER and it will find the correct info automatically and display it on one
screen. I don't want them to have to scroll. They do this many times a
day looking up customer info and it needs to be as painless as possible.

Thanks again.
Jon

 

[Dave Peterson]

Maybe you can teach them to use Edit|Find (or ctrl-f)

 

[Don Guillett]

That could be done using the filter method suggested and a worksheet_change
macro that would make it completely idiot proof.

 

[Guest]

The Vlookup() function is what you can use on a separate sheet.