Macro to Support a task in excel

  • Thread starter Thread starter VM
  • Start date Start date
V

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?
 
If I understand correctly what you want, a Pivot Table is what you
need.

HTH,
JP



- Show quoted text -
Click to expand...

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.
 
Back
Top