Create search in excel

G

Guest

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.
 
V

Vasant Nanavati

What would prevent Jhon from keying 1000 and seeing Abrahim's records?
_________________________________________________________________________
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top