View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sai Krishna[_2_] Sai Krishna[_2_] is offline
external usenet poster
 
Posts: 29
Default Returning a text by searching the whole workbook

Hi friends,

I have a master sheet containing the names of employees in one column and
their salaries in the adjacent column.

In the other sheets, I have the names of these very employees in specific
sheets which is named for each project they are working in.

Now not all employees are assigned a project.

Now I need to take out names of those employees in the master sheet whose
name does not figure in the other sheets, let us say project sheets.

I need to display this is a separate worksheet. The idea is to know who are
those associates who have not been assigned a project and thus available as a
free resource.

regards
krishna