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

HTH,
JP

On Mar 25, 6:49*am, VM wrote:
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?