find a certain name ????????
 

HI
I have a workbook that concerning engineering projects
B9=Project Name
C9=Project Code
F9= Followed by ex (John)
The workbook contains the main sheet with all the projects
I have opened a new sheet for all each employee ex :John
what i need is a formula that gives me all the projects that John is
following only

Can you help me with that ?

Tia

find a certain name ????????
 

Lookup Advanced Filters in the Help

"Tia" wrote:

HI
I have a workbook that concerning engineering projects
B9=Project Name
C9=Project Code
F9= Followed by ex (John)
The workbook contains the main sheet with all the projects
I have opened a new sheet for all each employee ex :John
what i need is a formula that gives me all the projects that John is
following only

Can you help me with that ?

Tia

find a certain name ????????
 

On Jun 4, 1:58*pm, Dennis wrote:
Lookup Advanced Filters in the Help



"Tia" wrote:
HI
I have a workbook that concerning engineering projects
B9=Project Name
C9=Project Code
F9= Followed by ex (John)
The workbook contains the main sheet with all the projects
I have opened a new sheet for all each employee ex :John
what i need is a formula that gives me all the projects that John is
following only

Can you help me with that ?

Tia- Hide quoted text -

- Show quoted text -

what i really need is to have a list of all the details and the
project that john is following and im not good in Vlookup

i need to open a cheet for all the employees


Please help