I need to have an excel macro written to distribute overtime hours as a weighted average across a number of activities.
The excel file is generated from a time keeping program. Each employee can have a different numbers of activities.
I have the formulas to calculate the time. I need help creating a macro to automate the process to run for all of the employees in the spreadsheet.
An example spreadsheet is attached. The first tab has the raw data as it is exported from the program. The second tab has the hours spread with the formulas that we have worked out.