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
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

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
 

Forum statistics

Threads
1,141,158
Messages
5,704,636
Members
421,360
Latest member
Rhodia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top