Display worksheet row data based on user input.

BenMngr

New Member
Joined
Oct 1, 2006
Messages
2
Help please! I have a worksheet that contains SS#, name, & dates in separate cells in a row. I would like to create a worksheet that requires a User to input their SS# to view the data in the row.

Basically creating a query based on a User inputting their SS#.

All other information will be hidden and locked for security purposes.

Thanks in advance!!

BenMngr
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi, BenMngr
Welcome to the Board !!!!!

a worksheet that contains SS#, name, & dates in separate cells in a row
some questions
what do you mean by dates ?
you would need a list of rows to show: so at least 3 columns with SS#, Name + rows to show: if name + password are correct then hide all rows except the "rows to show": is that what you want ?

kind regards,
Erik
 

BenMngr

New Member
Joined
Oct 1, 2006
Messages
2
My data consists of 600 rows and 5 columns. The columns identify SS#, Name, Birth Date, Hire Date, Text Field. Each row is for an individual.

I basically want to setup a form that asks the user to input his/her SS# then show the five fields for that SS#.

BenMngr
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
what do you mean by field ?
where are the 5 field-references ?

please post some sample data
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top