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

Why not just use, on the first sheet

datafilterautofilter

--
Don Guillett
SalesAid Software

"jonco" wrote in message
. net...
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

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

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

--

Dave Peterson

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


"jonco" wrote in message
. net...
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

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

jonco wrote:

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

"jonco" wrote in message
. net...
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


--

Dave Peterson

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

--
Don Guillett
SalesAid Software

"jonco" wrote in message
...
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


"jonco" wrote in message
. net...
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

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



"jonco" wrote:

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