Sample data is located on the "From This" worksheet. I want a macro that I run that creates a new sheet and does the following:
What I need created is similar to what a pivot table can do but I need a macro to perform this function.
The unique columns are going to be the emp# and projNo where I need to sum all the "Actual Hours Worked" for each projNo and emp#.
The edge case is then the projNo is 111-001 for a person. 111-001 projNo have five different places to put hours, Columns G - K. Those need to be summed and put in their respective columns.
"Do This" worksheet is the sample output.