Create search in excel
 

I have a work sheet which has multiple confidential employee information and
want to create a search in a 2nd sheet where employee can look only the
records with his employee ID.

Example:
Sheet 2 has
EmployeeID Employee Name Claim
1001 Jhon USD1000
1000 Abrahim USD150
1001 Jhon USD 10

Now would like to creat a search box in a second sheet hiding data sheet
(employee should not access this sheet) where employee can key his Employee
ID and retrieve the records against his ID.

In the above Jhon keys in 1001 and 2 records should display.

Please help this is required bit urgent.

Create search in excel
 

What would prevent Jhon from keying 1000 and seeing Abrahim's records?
__________________________________________________ _______________________

"Vinod Karthik" <Vinod wrote in message
...
I have a work sheet which has multiple confidential employee information
and
want to create a search in a 2nd sheet where employee can look only the
records with his employee ID.

Example:
Sheet 2 has
EmployeeID Employee Name Claim
1001 Jhon USD1000
1000 Abrahim USD150
1001 Jhon USD 10

Now would like to creat a search box in a second sheet hiding data sheet
(employee should not access this sheet) where employee can key his
Employee
ID and retrieve the records against his ID.

In the above Jhon keys in 1001 and 2 records should display.

Please help this is required bit urgent.

Create search in excel
 

currently I donot have control on this (any employee key other employee ID),
only I am trying to avoid employee browsing the entire data sheet (ie search
or filter) wasting time.
If there is a good alternative for the quesry of your, that would definately
help.


"Vasant Nanavati" wrote:

What would prevent Jhon from keying 1000 and seeing Abrahim's records?
__________________________________________________ _______________________

"Vinod Karthik" <Vinod wrote in message
...
I have a work sheet which has multiple confidential employee information
and
want to create a search in a 2nd sheet where employee can look only the
records with his employee ID.

Example:
Sheet 2 has
EmployeeID Employee Name Claim
1001 Jhon USD1000
1000 Abrahim USD150
1001 Jhon USD 10

Now would like to creat a search box in a second sheet hiding data sheet
(employee should not access this sheet) where employee can key his
Employee
ID and retrieve the records against his ID.

In the above Jhon keys in 1001 and 2 records should display.

Please help this is required bit urgent.