M
Manu001
Hi
I have an excel sheet with following columns
location username extension
there are about 500 users mentioned with various locations
in the worksheet.
location username extension
japan Gary Lios 1234
japan Gary lim 2345
hongkong Gary leo 5432
UK Mahesh D 9876
... and so on
One a seperate worksheet I want to create a search
function such that after selection the desired location
say japan and in user name entering gary I should be able
to view all the users who have names starting with Gary
and their respective extension.
Request all to direct me in correct direction.
I have an excel sheet with following columns
location username extension
there are about 500 users mentioned with various locations
in the worksheet.
location username extension
japan Gary Lios 1234
japan Gary lim 2345
hongkong Gary leo 5432
UK Mahesh D 9876
... and so on
One a seperate worksheet I want to create a search
function such that after selection the desired location
say japan and in user name entering gary I should be able
to view all the users who have names starting with Gary
and their respective extension.
Request all to direct me in correct direction.