Please have a look! (Need a VBA code)

[kk1990]

Hi All,

I am extremely new to VBA.
I need a vba code for the following problem

I have a sheet which contains Project's name in column C, corresponding Project manager's name in column E and status of the project in column G. Column J contains just the names of Project manger. The code should check the status of all the projects handled by a particular project manager and if any of the project is in "not updated" status, final output in column K should be "not updated" against the corresponding project manager.
If all the projects are in "updated" status for a particular project manager, final output in column K against his name should be "updated"

I have attached the file for reference

I will really grateful if anybody can help me out

Thanks

 

[Hui]

In Cell K5: =IF(COUNTIFS($E$5:$E$40,J5,$G$5:$G$40,"Not Updated"),"Not Updated","Up to date")
Copy down



No VBA Required !

 

[kk1990]

In Cell K5: =IF(COUNTIFS($E$5:$E$40,J5,$G$5:$G$40,"Not Updated"),"Not Updated","Up to date")
Copy down

View attachment 16158

No VBA Required !

Thanks @Hui