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