Hi all,
The macro I am trying to write a macro that will add up each employee's total hours from a various number of projects for the current week and up to 8 weeks in the future.
The tricky part is grouping the employees listed in one column and eliminating the duplicates and blank cells and then having the sum of total hours projected to work for each week listed next to the them in the respective column that corresponds with the correct week. There is another part that I am having trouble with too, which is sorting the engineer assigned hours from the CAD technician assigned hours (cells highlighted in sky blue).
I have attached the Excel spreadsheet and would like the summary to be located below the list of projects, but locating it on a different sheet would work too.
I have the "add project" and "new week" macros working perfectly.
thank you!
-norse
Bookmarks