Macro to Support a task in excel

[VM]

So I have a table list of employee IDs, along with the mutiple project
IDs and the hours against each project they have worked on.
I want to pull out the list of employee IDs with the project ID and
hours to which they have billed the maximum hours. Can anyone help
with a macro for this?

 

[JP]

If I understand correctly what you want, a Pivot Table is what you
need.

HTH,
JP

 

[VM]

If I understand correctly what you want, a Pivot Table is what you
need.

HTH,
JP



- Show quoted text -

I have got this list only through a pivot. I now need a macro to map
the project numbers with maximum hours to the employee code.